After someone reported a small bug in the “two INNER JOINs” diagram, I have created an update to the poster. This is update 4.1, only a minor version upgrade due to only a small change. The thing I love about the SQL Server community is the positive feedback that people give to help improve things. So many times I’ve been …

TSQL JOIN Types Poster (version 21.5) Read more »

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. This will help >>> Try our new JOIN Types Course I created this poster a few years ago and I keep it posted on the wall at the office. …

TSQL JOIN Types Poster (Version 4) Read more »

NOTE:: There is an updated version of the poster available now.   Version 4 is now available.   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. >>> Try my JOIN types course! I created this poster a …

TSQL JOIN Types Poster (Version 3) Read more »