Have you ever had difficulty remembering the difference between a LEFT OUTER JOIN and a RIGHT OUTER JOIN?

Free Download, the T-SQL JOIN types poster. (Version 4.1)

Download the T-SQL JOIN Types Poster


TsqlJoinTypes.pdf
T-SQL Join Types Poster (FREE)

Click to download the TsqlJoinTypes.pdf

The poster includes examples of INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, SEMI JOIN, ANTI SEMI JOIN, LEFT/RIGHT OUTER JOIN with exclusion, FULL OUTER JOIN, CROSS JOIN, FULL OUTER JOIN with exclusion, NON-EQUI INNER JOIN, CROSS APPLY, OUTER APPLY, TWO FULL OUTER JOINS, TWO INNER JOINS, EXCEPT, UNION and INTERSECT.