When I first created this JOIN Types poster or cheat sheet back in 2013 I didn’t realize there was such a need for it. I originally made this as a tool to explain JOIN types to a fellow coworker. It seemed almost impossible teach JOIN without it. The inspiration to create this tool came from a little bit of frustration. …

JOIN Types Poster Applause Read more »

This is part 18 “two inner JOINS” of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of JOINS, and when they should be used. Then we’ll explore some common uses for JOINS, such as replacing a not in clause with JOIN to get the same results with …

TSQL Basics Part 18: TWO INNER JOINS Read more »

This is part 2 “inner JOIN” of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of joins, and when they should be used. Then we’ll explore some common uses for joins, such as replacing a not in clause with join to get the same results with better …

TSQL Basics Part 2: Inner Join – Video Explanation Read more »