G
Guest
I have an unmatched query (Using the wizard) that is returning only a portion
of the results I need because there are two primary keys in the related
tables. I need to add a something to the SQL statement to account for the
Join on the second primary key but can't quite get it - any tips? SQL
statement is below I need to add a join on the field Formation.
SELECT Picks.Loc_ID, Picks.Top_Elev, Picks.Formation, Picks.SessionNum,
Picks.Deleted, Picks.Duplicated, Picks.PickDate, Picks.UniqueID,
Picks.xlocation04, Picks.ylocation04, Picks.elev04, Picks.Loc_Name04,
Picks.Loc_Name_Alt1_04, Picks.xlocation06, Picks.ylocation06, Picks.elev06,
Picks.Loc_Name06, Picks.Loc_Name_Alt1_06, Picks.GndElevChange
FROM Picks LEFT JOIN [RG Picks] ON Picks.Loc_ID = [RG Picks].Loc_ID
WHERE ((([RG Picks].Loc_ID) Is Null));
of the results I need because there are two primary keys in the related
tables. I need to add a something to the SQL statement to account for the
Join on the second primary key but can't quite get it - any tips? SQL
statement is below I need to add a join on the field Formation.
SELECT Picks.Loc_ID, Picks.Top_Elev, Picks.Formation, Picks.SessionNum,
Picks.Deleted, Picks.Duplicated, Picks.PickDate, Picks.UniqueID,
Picks.xlocation04, Picks.ylocation04, Picks.elev04, Picks.Loc_Name04,
Picks.Loc_Name_Alt1_04, Picks.xlocation06, Picks.ylocation06, Picks.elev06,
Picks.Loc_Name06, Picks.Loc_Name_Alt1_06, Picks.GndElevChange
FROM Picks LEFT JOIN [RG Picks] ON Picks.Loc_ID = [RG Picks].Loc_ID
WHERE ((([RG Picks].Loc_ID) Is Null));