Skip to Main Content

Write Great SQL Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

October 19, 2021

13:00 UTC   Start Times Around the World

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.


Visualizing SQL joins - back to basics
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

Your Experts

    Chris Saxon

    Chris Saxon   

    Chris Saxon is an Oracle Developer Advocate and quizmaster on Dev Gym. His job is to help you get the best out of the Oracle Database and have fun with SQL! He's also part of the answer team on Ask TOM and creates YouTube videos at The Magic of SQL channel.
    Mike Durran

    Mike Durran   

    I'm a Product Manager in the Oracle Analytics team, my focus is on helping developers built custom applications that take advantage of the power of Oracle Analytics.