A cheatsheet for sql joins

sql-joins-cheatsheet.sql

-- Inner Join
SELECT * FROM A INNER JOIN B ON A.key = B.key

-- Left Join
SELECT * FROM A LEFT JOIN B ON A.key = B.key

-- Left Join without Intersection
SELECT * FROM A INNER JOIN B ON A.key = B.key where B.key IS NULL

-- Right Join
SELECT * FROM A RIGHT JOIN B ON A.key = B.key

-- Right Join without Intersection
SELECT * FROM A RIGHT JOIN B ON A.key = B.key where B.key IS NULL

-- Full Join
SELECT * FROM A FULL JOIN B ON A.key = B.key 

-- Full Join without intersection
SELECT * FROM A FULL JOIN B ON A.key = B.key where A.key IS NULL OR B.key IS NULL