Free Poster
by Stedman Solutions LLC.
Download my Join Types
Poster today!
Just complete this form and you will receive a free download of my Join Types poster. Download a printable PDF to hang on your office wall.
Added Bonus: 65% off coupon for my Join Types class when you download the poster.
“A great pair of posters to help visualize and code #TSQL JOINs”
What you get:
Download the PDF of the SQL Server and MySQL Join Types poster and uses it to better visualize what your JOINS are doing.
The diagram shows the following: INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, LEFT OUTER JOIN with exclusion, RIGHT OUTER JOIN with exclusion, FULL OUTER JOIN, CROSS JOIN, FULL OUTER JOIN with exclusion, two INNER JOINs, two FULL OUTER JOINs, and two LEFT OUTER JOINs.
What is it all about?
So many times I have been asked for help with a query, where the question really comes down to the understanding of the difference between INNER and LEFT or RIGHT JOINs. I created this poster a few years ago and I keep it posted on the wall at the office. This way when I am trying to explain JOIN types, I just refer to the poster.
I have created the poster to help describe JOIN types in SQL Server. This had lead to lots of confusion over time, and this is the best way that I have seen to describe them.