INNER JOIN

SELECT <fields>
FROM A
INNER JOIN B ON (A.key = B.key)

LEFT JOIN

SELECT <fields>
FROM A
LEFT JOIN B ON (A.key = B.key)

 

RIGHT JOIN

SELECT <fields>
FROM A
RIGHT JOIN B ON (A.key = B.key)

 

OUTER JOIN

SELECT <fields>
FROM A
FULL OUTER JOIN B ON (A.key = B.key)

 

LEFT ONLY JOIN

SELECT <fields>
FROM A
LEFT JOIN B ON (A.key = B.key)
WHERE B.key IS NULL

 

RIGHT ONLY JOIN

SELECT <fields>
FROM A
RIGHT JOIN B ON (A.key = B.key)
WHERE A.key IS NULL

 

LEFT ONLY AND RIGHT ONLY JOIN

SELECT <fields>
FROM A
RIGHT JOIN B ON (A.key = B.key)
WHERE A.key IS NULL AND B.key IS NULL