Page 1 of 1

T-SQL join types

Posted: Sat Feb 22, 2020 1:40 am
by stararound
Tham khảo từ Steve Stedman: http://stevestedman.com/wp-content/uplo ... nTypes.pdf

SELECT from 2 tables - not join
Image

INNER JOIN
Image

LEFT OUTER JOIN
Image

RIGHT OUTER JOIN
Image

SEMI JOIN
Image

ANTI SEMI JOIN
Image

LEFT OUTER JOIN with exclusion - replacement for a NOT IN
Image

RIGHT OUTER JOIN with exclusion - replacement for a NOT IN
Image

FULL OUTER JOIN
Image

CROSS JOIN
Image

FULL OUTER JOIN with exclusion
Image

NON-EQUI INNER JOIN
Image