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
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.