title: Insert Into Table B Select * From Table A, but with an extra column in Table B, is it possible?
body: <p>I have Table A and Table B. Table A has columns A, B and C and Table B has columns A, B, C <strong>and D</strong>.</p>
  
  <p>If I do the following:</p>
  
  <pre><code>INSERT INTO TableB
  SELECT * FROM Table A
  WHERE (....)
  </code></pre>
  
  <p>Will it allow me to do it, even with the extra column that the Table B has? I'm trying to do this in my project, however, they told me that the Table B should have the same columns as Table A but with an extra one. </p>
  
  <p>Thanks.</p>