Why are joins denoted left, right, inner, outer

[AJR]

Hi

Can't seem to find an explanation for why joins are denoted as left/right or Inner/Outer. If I know why it would probably help me remember which is which.

Thanks

AJR

 

[jdraw]

see
http://www.w3schools.com/sql/sql_join.asp

 

[John Big Booty]

This article seems to have a pretty good explanation of the various joins. This article has a handy table to show you how the various joins operate and where to use them.

 

[AJR]

Thanks for the links. I'm on my way over now

AJR