Understanding Joins
The capability to join tables is probably the most important feature of MySQL, so it is important that you understand how to construct a SELECT statement that includes a join.
Understanding Relational Tables
MySQL is a relational database. This means that data records can be split across several tables in a logical way. You will learn how to design a relational database in Lesson 16, “Designing Your Database,” so for now, you’ll consider a simple example from the sample tables that you have already seen.
A relationship exists between the customers and customer_contacts tables. There might be more than one contact person for each customer, assuming that a customer is a company and that you can deal with people in different ...
Get Sams Teach Yourself 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.
