A LEFT OUTER JOIN with exclusion is a type of JOIN operation in SQL that combines data from two tables, based on a JOIN condition, and excludes the rows that match the JOIN condition. This type of JOIN is called an outer JOIN with exclusion because it includes the rows from the left (or first) table that do not have …
This is part 7 “left outer join with exclusion” 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 …
TSQL Basics Part 7: LEFT OUTER JOIN w/ exclusion – Video Explanation Read more »