I have failed to understand the 'properties' in the join in a query.
I have one table which I need to show all club names in the resultant
query. The second table will supply the posts which have been filled
and leave me with a result showing the clubs which have failed to
make nominations.
The properties show as: "Include all records from "ClubsActive".
Why do I not se them in the result?
SELECT ClubsActive.ClubName, tClubPostHolders.YearID, tClubPostHolders.ClubID
FROM ClubsActive LEFT JOIN tClubPostHolders ON ClubsActive.ClubID =
tClubPostHolders.ClubPostID
WHERE (((tClubPostHolders.YearID)=85) AND ((tClubPostHolders.ClubID)=19));
Many thanks,
Robin Chapple
__._,_.___
MARKETPLACE
.
__,_._,___
Tidak ada komentar:
Posting Komentar