<?xml version="1.0" encoding='utf-8'?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">
<wml>
<card id="card1" title="Join (SQL) - Page 1 - Wikipedia">
<p>
<a accesskey="3" href="page.php?w=Join_%28SQL%29&amp;p=2">3.Next</a>
</p>
<p>A <b>join</b> clause in the Structured <a href="page.php?w=Query_language">Query Language</a> (<a href="page.php?w=SQL">SQL</a>) combines <a href="page.php?w=column_%28database%29">columns</a> from one or more <a href="page.php?w=table_%28database%29">tables</a> into a new table. The operation corresponds to a <a href="page.php?w=Join_%28relational_algebra%29">join operation in relational algebra</a>. Informally, a join stitches two tables and puts on the same row records with matching fields. There are several variants of <code>JOIN</code>:</p><p>
<a accesskey="3" href="page.php?w=Join_%28SQL%29&amp;p=2">3.Next</a>
</p>

<do type="prev" label="Search">
        <go href="search.wml"/>
</do>

</card>
</wml>
