Microsoft, Access, 2003, clarification on definitions of right and left outer joins
Posted on 2007-08-09
I have read two different books which offer opposite definitions of left and right outer joins.
This is my understandin, and please correct me:
Right outer join: Include all records in the right table and only records in the left table where there is a match in the joined field.
Left outer join is opposite.
Is left or right arbitrarily assigned if you are just programming in SQL vs. using the QBE? Just confusing. Thanks so much.