JOIN Operations

Combine data from multiple tables using INNER JOIN, LEFT JOIN, and RIGHT JOIN. ## Lesson objectives In this lesson, we will learn how to combine data from multiple tables in SQL. In the previous lessons, we worked mostly with one table. We used to choose columns, to filter rows, to sort results, to group rows, and to filter groups. But in real databases, data is usually not stored in one single table. Data is often split into separate tables.