Microsoft, Access, 2003, clarification on definitions of right and left outer joins

Hello,

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.
dustyworkAsked:
Who is Participating?
 
Daniel WilsonConnect With a Mentor Commented:
"right" vs "left" is simply a matter of which table is on which side of the JOIN keyword.

Table1 Left Join Table2
is equivalent to
Table2 Right Join Table1

You will probably develop your own style for using those joins.  My standard is that I always use LEFT joins.  Mixing LEFT's and RIGHT's tends to confuse 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."

Correct.
0
 
peter57rCommented:
You can use Left and Right joins in the query grid.
Right-click the join line and choose Join Type.  You will be asked a sensible Q for once!
0
 
dustyworkAuthor Commented:
Daniel,

Thanks for the feedback.  You've cleared things up nicely and given me a good technique to use going forward.  Alas, the sea of SQL is looking less choppy for me!

Peter57r, thanks for taking the time to offer your insight as well.

Wishing you both the best and greatful for your time.

Kind Regards,
Dusty
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.