Chapter 4Working with Multiple Tables
Next to the table, the most important concept in the world of relational databases is, not surprisingly, relationships. Very early on in our discussions you saw how a record can be organized across multiple tables—each row in a table being part of a larger whole. It follows, then, that you’ll sometimes find the need to work with several tables at the same time.
This chapter is all about working with multiple tables. In it’s first
half, we’ll continue with SELECT, and you’ll learn how to reference more than one table in the same statement. I’ll show you why this is useful and the different ways the tables can be combined. Depending on the number of tables and how they are related, things can start to get a ...
Get Jump Start MySQL 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.
