ion
and have data separated into two tables, linked together using
primary and foreign keys, we need to be able to build a 
<tt>SELECT</tt> that re-assembles the data across the tables.<br />
<br />
SQL uses the <tt>JOIN</tt> clause to re-connect these tables. 
In the <tt>JOIN</tt> clause you specify the fields that are used 
to re-connect the rows between the tables.<br />
<br />
The following is an example of a <tt>SELECT</tt> with a 
<tt>JOIN</tt> clause:
</font><pre><font size="4" color="blue">
SELECT *