title: Create table as select with join
body: <p>I need to create table with all un matching id's between table A and table B. Both the tables have some matching fields , but I would need all the columns from table A only</p>
  
  <p>Table A</p>
  
  <pre><code>ID NAME address       Phone
  12  xyz  some street   1234566
  22  xyz  some street   1234566
  3  xyz  some street   1234566
  </code></pre>
  
  <p>Table B</p>
  
  <pre><code>ID Vendor_NAME address       Phone    email
  1  xyz         street       1234566  xyz@gmail.com
  2  xyz         street       1234566
  3  xyz         street       1234566
  </code></pre>
  
  <p>Resulting table- Table C</p>
  
  <pre><code>ID NAME address       Phone
  12  xyz  some street   1234566
  22  xyz  some street   1234566
  </code></pre>
  
  <p>I am using this query to get all the un-matching values from table A</p>
  
  <pre><code>select *  from A left join B on A.ID=B.ID where B.ID is null
  </code></pre>
  
  <p>This gives me all the fields from table A and Table B. How do I create  table C so that it would have only the un-matching values and fields from table A.</p>
  
  <p>Updating a Table B with Table C</p>
  
  <p>Table B</p>
  
  <pre><code>ID   Vendor_NAME           street_address Phone    email
  1  xyz         street         1234566  xyz@gmail.com
  2  xyz         street         1234566
  3  xyz         street         1234566
  </code></pre>
  
  <p>Table C</p>
  
  <pre><code>ID  NAME  address        Phone
  12  xyz   some street    1234566
  22  xyz   some street    1234566
  </code></pre>
  
  <p>Update table B</p>
  
  <pre><code>ID   Vendor_NAME           street_address Phone    email
  1     xyz                   street         1234566  xyz@gmail.com
  2     xyz                   street         1234566
  3     xyz                   street         1234566
  12    xyz                   some street      1234566
  22    xyz                   some street      1234566
  </code></pre>
  
  <p>Table B has the same data , but with different column names and would have few extra columns. I would like to insert all the data from table C table B.</p>