Tag: inner and outer join

By Posted on Posted in Classes, JOIN Types, TSQL No Comments Tagged with , , , , ,

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 »

By Posted on Posted in JOIN Types, TSQL No Comments Tagged with , ,

This is part 15 “inner and outer 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 …

TSQL Basics Part 15: INNER AND OUTER JOIN – Video Explanation Read more »