Print Friendly, PDF & Email

SQL Failed Column 'MasterPairing' in field list is ambiguous
SELECT Pairing,MasterPairing FROM wp_DSI_PlayRoster r join wp_DSI_playdates pd on r.Clubname=pd.Clubname where dt='2019-04-29' and r.ghin = '8525618';

SQL Failed Column 'MasterPairing' in field list is ambiguous
SELECT MasterPairing,Pairing,pd.Clubname ClubName,MasterPairing,r.lname,r.fname,r.* FROM wp_DSI_PlayRoster r join wp_DSI_playdates pd on r.Clubname=pd.Clubname where dt='2019-04-29' and pairing='' order by r.ClubName, Lname, Fname;
NameQuotaPointsScore