Try our JOIN types course today!
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 below 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.
If you are looking for the MySQL version of the poster, click here.
click to download JoinTypes.pdfSee Also:
Comes Complete with:
• Easy to understand lectures with examples
• Assignments
• Sample code to work with
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!
What about LATERAL joins?
Good points, LATERAL JOINS, including CROSS APPLY would be nice to add. Perhaps on version 3 of the poster.
Great idea– awesome poster! Can you please put your version number somewhere in the poster so that I can keep track of which one I am looking at. Also, an Oracle version would be nice. Thanks for all your contributions to the SQL community!!
The poster suggests that FULL JOIN is the same as CROSS JOIN, which of course it isn’t.
Yes, the posters does give that illusion.
This post explains the difference.
http://stevestedman.com/2015/03/full-outer-join-vs-cross-join/
Yes, they both include all rows from both the LEFT and RIGHT side of the JOIN, however they are matched up or JOINed in a very different way.
Thank you for the poster.
nice explanation sir i saw ur vedios,it amaizing and i need to join with ur class
Very nicely put…thank you. I am downloading your the pdf version.