T-SQL join types

[stararound]

Tham khảo từ Steve Stedman: http://stevestedman.com/wp-content/uplo ... nTypes.pdf

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