Joining tables in SQL Server can be confusing and hinder your performance. I know because I have helped many confused people to understand their JOINs.
That is why I created the JOIN Types cheat sheet several years ago, and the JOIN Types class last year.
I have recently updated my poster to version 22.
I have also made many blog posts relating to JOINS over the years. See below!
65% Off – Microsoft TSQL JOIN Types
For the month of April
Coupon Code: POSTER
JOIN Types Blog Posts:
TSQL Basics Part 19: TWO LEFT OUTER JOINS – Video Explanation
TSQL Basics Part 18: TWO INNER JOINS
TSQL Basics Part 17: TWO FULL OUTER JOINS
TSQL Basics Part 15: INNER AND OUTER JOIN – Video Explanation
TSQL Basics Part 14: FULL OUTER JOIN w/ exclusion – Video Explanation
TSQL Basics Part 13: EQUI vs NON EQUI JOIN – Video Explanation
TSQL Basics Part 12: OUTER APPLY – Video Explanation
TSQL Basics Part 11: CROSS APPLY – Video Explanation
TSQL Basics Part 10: CROSS JOIN – Video Explanation
TSQL Basics Part 9: FULL OUTER JOIN – Video Explanation
TSQL Basics Part 8: RIGHT OUTER JOIN w/ exclusion – Video Explanation
TSQL Basics Part 7: LEFT OUTER JOIN w/ exclusion – Video Explanation
TSQL Basics Part 6: ANTI SEMI JOIN – Video Explanation
TSQL Basics Part 5: SEMI JOIN – Video Explanation
TSQL Basics Part 4: RIGHT OUTER JOIN – Video Explanation
TSQL Basics Part 3: LEFT OUTER JOIN – Video Instruction
TSQL Basics Part 2: Inner Join – Video Explanation
TSQL Basics Part 1: Basic JOIN – Video Explanation
TSQL Basics: SQL Server Join Types Webinar
Exploring SQL Server JOIN Types
TSQL JOIN Types Poster (version 21.5)
TSQL JOIN Types – SQL Saturday
TSQL JOIN Types Poster (Version 4)
MySQL JOIN Types for LinuxFest Northwest
TSQL JOIN Types Poster (Version 3)
TSQL OUTER JOINS (LEFT and RIGHT)
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!