Work With Joins

Why do we need joins?

Our queries have gotten more complex and expressive with the addition of the where option and its functions. But so far, we’ve only been working with one table at a time. When we need to query across multiple tables at once, we’ll need joins. In this section, we’ll see how to add joins to our queries and learn how to change our select option to make results from multiple columns easier to read.

The term “join” comes from SQL. It’s a language feature that allows us to combine data from two or more tables within the same query. Joins come ...