Save the results of a join statement? SQL
<p>I'm able to join three tables together, but I can't figure out a way to save the resulting table. The join statement I am using is:</p>

<pre><code>SELECT * FROM
Table1
INNER JOIN Table2
ON Table1.id = Table2.id
INNER JOIN Table3
ON Table1.id = Table3.id
</code></pre>

<p>I've tried INSERT INTO, SELECT INTO, etc., and I am still unable to find a way to save the following query as a table. This must be possible, but I can't figure it out!</p>

<p>id is a shared identifier for all tables.</p>