8. INNER JOINs
“Do not quench your inspiration and your imagination;do not become the slave of your model.”
—Vincent van Gogh
Topics Covered in This Chapter
Up to this point, we have primarily focused on solving problems using single tables. You now know how to get simple answers from one table. You also know how to get slightly more complex answers by using expressions or by sorting the result set. In other words, you now can draw the perfect eyes, chin, mouth, or nose. In this chapter, we’ll show you how to link or join multiple parts to form a portrait.
What Is a JOIN?
In Chapter 2, “Ensuring Your Database Structure Is Sound,” we emphasized ...
Get SQL Queries for Mere Mortals®: A Hands-On Guide to Data Manipulation in SQL, Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
