SQL Join 3 Tables: How-To with Example

When working with SQL, you'll learn to join two tables together so you can get data from both of the tables.

But what about joining 3 tables?

This is possible to do in SQL. It works in a similar way to joining two tables and can be extended to join to 4 or 5 or many more tables.

In this video, you'll learn how to join 3 tables together in an SQL query, and follow a step-by-step example of a query that does this.

[MfknLemonBob]

This video saved me. You explained this better than a text book, 15 minutes video, and a lecture from my prof combined did. Thank you

[bhumikalamba]

Thanks for the lucid explanation. 
Summary:
1. SELECT columns to show from the first table
2. (INNER/OUTER) JOIN to the second table
3. add the columns to join ON
4. add any additional columns to step 1.
5. (INNER/OUTER) JOIN to third table
6.add the columns to join ON . The columns can belong to the first/second table and then join it with the column for the third table
7. add any additional columns to step 1.

[kalenwilson]

I have been trying to make sense of joins for the past 4 weeks - but the very essence of it had eluded me. NOW I understand! Thank you for simplifying this to the point where even I could understand it!

[bebe]

hours upon hours of trying to figure this stuff out and your short video was all i needed. wish I could have found it sooner. THANKS!!

[BensLab]

Thank You! I've been banging my head against a wall trying to figure this out. This video finally helped me. Many many thanks!

[jeanettemartinez]

Thank you! I have watched so many videos where I get completely lost. I was able to follow along in the order and understand how! I really appreciate you and the method you teach.

[antrahagure]

Thanks to this video I passed my assignment. The best part is where you explain how to add the third table that’s where I was stuck and you bailed me out.

Thank you very much!

[joadhra]

Thank you so much! Just 2 words, "Amazing Explanation"

[vanpham]

Extremely easy to understand. Thank you so much for this!!!!

[petecarroll]

Thank you sir, could not have finished my MySQL project without. Thank

[damisohutchinson]

Ive been rattling my brain for over an hour...to do what you did in 4:05....thank you

[NOLONGERANONYMOUS]

Needed to turn a setting off on certain records in one table based off of a category stored in another table. I'm just beginning to learn SQL for my job and this helped!

[sharonaddo]

Bless your Thank you so much for this quick clear and easy explanation

[Jorhanny]

You are a life saver, I am assuming this can be applied for even more than 3 tables, I definitely need to master MySQL for college projects, tysm.

[akutiaakuti]

Clear and simple presentation, thank you very much

[zabialy]

Great video, still very relevant after 2 years!

[aiasaiascon]

In general - is it a more preferable method to add columns from the JOINs on a step by step pace ? And while following these steps, do you use a notepad (e.g) to write temporarily some parts of the SQL query ?

[The.Wellerman]

Thank you thank you! This helped me with a project for school. Thank you a ton!

[redlobsta]

it would be great if you could include what the tables originally looked like and how they look after each statement.

[applikai]

The diagram at the beginning of the table is misleading. It shows it as A join B, B join C and A join C. The query however is just two joins, A join B, A join C. I was expecting the video to be dealing with a circular join. Thank you and keep them good videos on complex data modeling concepts coming.