SQL JOIN: Condition in “ON” vs. “WHERE"
See full Playlist at • SQL Query Foundations
00:00 Introduction
01:37 Three JoinTypes
02:12 Sample Data
03:07 Cross Join
04:06 Inner Join
05:01 Outer Join Terminology
05:56 Left Outer Join
06:51 Right Outer Join
07:49 Full Outer Join
08:23 Points To Note
08:43 Recap ... 4 Takeaways
09:31 Test your understanding - Problem
10:21 Test your understanding - Solution
A solid understanding of how SQL JOINs work is a must for anyone working with SQL queries. This tutorial explains the three basic Join types - Cross, Inner and Outer, and the logical steps executed by the SQL engine to compute each join type. Unlike explanations that rely on Venn diagrams, this simple explanation of SQL Joins is something you will easily remember!
Acknowledgement: Based on the explanation in T-SQL Fundamentals by Itzik Ben-Gan.