SQL joins are a commonly used feature when writing queries. They let you combine two (or more) tables together in your SQL query and see a single set of results. In this video, you'll learn a bit more about what SQL joins are, why they are needed, the different types of joins, and examples of each in a SELECT query. I'll also share a few tips on working with joins and things to avoid. Related videos: How to Join 3 Tables: https://www.youtube.com/watch?v=TGt2xa7EzvI Self Joins: https://www.youtube.com/watch?v=7T8b7g7aV1A Timestamps: 00:00 Start 00:16 What is a join? 00:48 Sample tables 01:38 Start of query 01:58 Inner Join 04:49 Left Outer Join 06:10 Right Outer Join 07:10 Full Outer Join 07:38 Joins are not bad 08:16 Using keyword 08:46 Natural Join 09:17 Joins in a Where clause /// RESOURCES 📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-cheat-sheets/ 🧭 SQL Roadmap from basics to advanced: https://www.databasestar.com/sql-roadmap/ ✍️ Learn how to design a database: https://databasestar.mykajabi.com/edd 🎓 Improve your SQL and database skills with Database Star Academy: https://www.databasestar.com/dsa/ 📧 Contact me here: https://www.databasestar.com/contact/ 📝 Database Design Exercises: https://bbrumm.gumroad.com/l/hqsxi 📝 SQL Practice Questions: https://bbrumm.gumroad.com/l/ulekqk 📝 SQL Performance Quick Guide: https://bbrumm.gumroad.com/l/fcvny 📝 Ultimate SQL How-To Guide: https://bbrumm.gumroad.com/l/oqggau