There are many types of join in SQL including inner, outer, and cross.
But how do these affect which rows are in the result set?
In this session Chris used Oracle Analytics Cloud to show you how different join types affect the rows that appear in the result set.
Highlights include:
02:30 - Cross joins
05:00 - Inner joins
07:40 - Inner joins on many columns
08:30 - Band joins
10:40 - Non-equijoin
12:40 - Left outer join
14:00 - Right outer join
16:00 - Filtering the inner table in an outer join
19:10 - Partitioned outer join
22:30 - Full outer join
24:30 - Cross apply
28:30 - Outer apply
30:40 - Outer joins with the (+) operator instead of join clause
33:20 - Joins with the using clause
47:00 - Natural joins
Learn SQL for free http://bit.ly/learn-sql-free-dfd-f
