SELECT * FROM books JOIN authors ON books.author_id = authors.id;
JOIN clause allows for the return of results from more than one table by joining them together with other results based on common column values specified using an
INNER JOIN is the default
JOIN and it will only return results matching the condition specified by
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!