Figure A-10 displays the joins in the stores7 database. The lines connecting a column in one table to the same column in another table indicate the relationships, or joins, betweentables.
According to Figure A-11, customer 104 (Anthony Higgins) has placed two orders, as his customer number appears in two rows of the orders table. Because the customer number is a foreign key in the orders table, you can retrieve Anthony Higgins' name, address, and information about his orders at the same time.
