Chapter 10. Joins and Unions: Multiple-Table Operations
Welcome to a multi-table world. It’s great to have more than one table in your database, but you’ll need to learn some new step sequences to get your tables to partner with each other. Joins help you momentarily match up relevant data from tables you intentionally separated for clarity and organization. And as you’ll soon learn, there are several different join maneuvers for pairing your tables. The words cross join, inner join, left join, right join, and full outer join may not glide through your mind just yet, but by the end of this chapter, you’ll know them well enough to pick the best join for scoring big with the judges. You’ll also meet the self join for that solo work and UNION to combine the results of multiple queries. With these new tricks under your skates, you’ll soon know how to get all of your data together, in any synchronized form you need.
Time to JOIN the party
Camp Calloway’s data administrator, Mrs. Murphy, is fully recovered and back at the helm. Coach Collins did his best to organize the campers’ information while she was away in Chapter 9, but now the real data fun begins.
If you’ve ever heard anyone talking about SQL, you’ve probably heard the word “join” tossed around. Joins aren’t as complicated ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
