SELECT from 2 tables - not join

INNER JOIN

LEFT OUTER JOIN

RIGHT OUTER JOIN

SEMI JOIN

ANTI SEMI JOIN

LEFT OUTER JOIN with exclusion - replacement for a NOT IN

RIGHT OUTER JOIN with exclusion - replacement for a NOT IN

FULL OUTER JOIN

CROSS JOIN

FULL OUTER JOIN with exclusion

NON-EQUI INNER JOIN
