title: Create Table Through JOIN SQL
body: <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>