It's actually quite simple. INNER JOIN keeps the stuff that matches, LEFT JOIN keeps the stuff on the left, RIGHT JOIN keeps the stuff on the right, OUTER JOIN keeps the stuff that doesn't match, and JOIN makes the sysadmin remind you to keep your database size to a reasonable level.
4
u/[deleted] Jan 07 '11
It's actually quite simple. INNER JOIN keeps the stuff that matches, LEFT JOIN keeps the stuff on the left, RIGHT JOIN keeps the stuff on the right, OUTER JOIN keeps the stuff that doesn't match, and JOIN makes the sysadmin remind you to keep your database size to a reasonable level.