Create Table Through JOIN SQL
<p>I need to create a new table in my database through a left join statement of 2 tables from different schemas.  Here is my code below:</p>

<pre><code>CREATE TABLE NEW_TABLE
  FROM SCHEMA_1.TABLE_A X
  LEFT JOIN SCHEMA_2.TABLE_B Y
     ON X.NAME = Y.NAME 
        AND X.NUMBER = Y.NUMBER
</code></pre>

<p>I'm getting a SQL error: </p>

<blockquote>
  <p>ORA-00922: missing or invalid option<br>
  00922. 00000 -  "missing or invalid option" </p>
</blockquote>

<p>Any help would be greatly appreciated.  Thanks.</p>