8INNER 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

What Is a JOIN?

The INNER JOIN

Uses for INNER JOINs

Sample Statements

Summary

Problems for You to Solve

Up to this point, I 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, I’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,” I emphasized ...

Get SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th 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.

Start your free trial