SQL Joins

W3Schools has a great SQL section.  Included are:

The "outer" joins come in two flavors.  And now you can see why it doesn't make sense to have Left and Right INNER joins.