T-SQL join types

Post Reply
User avatar
stararound
Posts: 22
Joined: Wed Apr 17, 2019 1:29 pm

T-SQL join types

Post 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

Post Reply