SELECT column_name(s) FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;
An outer join will combine rows from different tables even if the join condition is not met. In a
LEFT JOIN, every row in the left table is returned in the result set, and if the join condition is not met, then
NULL values are used to fill in the columns from the right table.
Lyft Trip Data
It's time to build fluency in SQL fundamentals. In this next Pro Project, we're going to practice using multiple tables in SQL so you can hone your skills and feel confident taking them to the real world. Why? It's important to understand how to interact with multiple tables in a single query. What's next? A data analyst, ride sharing, more SQL. You got this!