Sams Teach Yourself PHP, MySQL® and Apache All in One

Selecting from Multiple Tables

You're not limited to selecting only one table at a time. That would certainly make application programming a long and tedious task! When you select from more than one table in one SELECT statement, you are really joining the tables together.

Suppose you have two tables: fruit and color. You can select all rows from each of the two tables, using two separate SELECT statements:

						mysql> select * from fruit;
+----+-----------+
| id | fruitname |
+----+-----------+
|  1 | apple     |
|  2 | orange    |
|  3 | grape     |
|  4 | banana    |
+----+-----------+
4 rows in set (0.00 sec)

mysql> select * from color; +----+-----------+ | id | colorname | +----+-----------+ | 1 | red | | 2 | orange | | 3 | purple | | 4 | yellow | +----+-----------+ ...