Section 2.1
Joins
In this section, we will only discuss
inner joins, and equijoins, as in general, they are the most useful.
For more information, try the SQL links at the bottom of the page.
Good database design suggests that each table lists data only about a single
entity, and detailed
information can be obtained in a relational database, by using additional tables, and by using a
join.
First, take a look at these example tables:
AntiqueOwners
OwnerID OwnerLastName OwnerFirstName
01 Jones Bill
02 Smith Bob
15 Lawson Patricia
21 Akins Jane
50 Fowler Sam