SQL Joins Cheatsheet
LEFT JOIN
SELECT * FROM T1
LEFT JOIN T2
ON T1.NAME = T2.NAME
INNER JOIN
SELECT * FROM T1
INNER JOIN
ON T1.NAME = T2.NAME
RIGHT JOIN
SELECT * FROM T1
RIGHT JOIN
ON T1.NAME = T2.NAME
LEFT JOIN (EXCLUDE T2)
SELECT * FROM T1
LEFT JOIN T2
ON T1.NAME = T2.NAME
WHERE T2.ID IS NULL
UNION ALL (EXCLUDE INNER)
SELECT * FROM T1
LEFT JOIN ON T1.NAME = T2.NAME
WHERE T2.ID IS NULL
UNION ALL
SELECT * FROM T1
RIGHT JOIN T2 ON T1.NAME = T2.NAME
WHRE T1.ID IS NULL
RIGHT JOIN (EXCLUDE T1)
SELECT * FROM T1
RIGHT JOIN T2
ON T1.NAME = T2.NAME
WHERE T1.ID IS NULL
FULL OUTER JOIN
SELECT * FROM T1
FULL OUTER JOIN T2
ON T1.NAME = T2.NAME
UNION ALL
SELECT * FROM T1
LEFT JOIN T2 ON T1.NAME = T2.NAME
UNION ALL
SELECT * FROM T1
RIGHT JOIN T2 ON T1.NAME = T2.NAME
WHERE T1.ID IS NULL
link: sysxplore.com