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:


OwnerID OwnerLastName OwnerFirstName

01 Jones Bill

02 Smith Bob

15 Lawson Patricia

21 Akins Jane

50 Fowler Sam

                                        page: 1 from 1