Left join vs Right join

Ok, so I'm starting to get the hang of basic inner joins, still confused on Left and Right though. I know the end result of each but I am a little confused on the syntax;

This is regarding Microsoft SQL

so, if I use a regular join;

Please Login or Register  to view this content.

Easy enough

Return results where there is a match on both sides, full join


But for Left/Right joins, I know it is to return all values from either the Left or Right, as in all results from Table1, return NULLS if no match in Table2, but where does left/right come into play?

Which one of these, if any is correct?

Color code; when using
LEFT
RIGHT


is it reading the code as;
Table1 JOIN Table2 on Table1.Field1 = Table2.Field1
or
Table1 JOIN Table2 on Table1.Field1 = Table2.Field1
or
Table1 JOIN Table2 on Table1.Field1 = Table2.Field1

Does this make sense?

Got it, so the LEFT/RIGHT qualifier is referring to the table listed Left/Right of the word JOIN as in my first of three possibilities, not the ON or the ='s listed in the other two. That answers my question, thanks!

An example of these Joins will be like this.....

Left Join:

Please Login or Register  to view this content.

This will return all the rows from the left table(Employees) even if there are no matches in the right table (Orders).

Right Join:

Please Login or Register  to view this content.

This will return all the rows from the right table (Empoyees) even if there are no matches in the left table (Orders).