title: INSERT - SELECT * instead of one column
body: <p>Looking for easy way to insert select column values :</p>
  
  <p>Example</p>
  
  <pre><code>TableA    TABLEB
  -----------------
  Field1    Field1
  Field2    Field2
  Field3    Field3
  Field4    Field4
  Field5    Field5
            FleldX
  </code></pre>
  
  <p>My tables contain around 80 columns. Now I want just to copy data from one table to another, like:</p>
  
  <pre><code>Insert Into table B (Field1, Field2, Field3, Field4, Field5, FieldX) 
  VALUES SELECT (Field1, Field2, Field3, Field4, Field5, 'HARDCODEVALUE') 
         FROM TableA
  </code></pre>
  
  <p>Do I need to set explicit all 80 column names, or the best solution would be if it map fields automatically so I can set like this</p>
  
  <pre><code>Insert Into table B (Field1, Field2, Field3, Field4, Field5, FieldX) 
  VALUES
      SELECT (Field4, Field3, Field2, Field1, Field5, 'HARDCODEVALUE' AS FieldX) 
      FROM TableA  
  </code></pre>
  
  <p>Where I can reorder column names and SQL do other for me?</p>
  
  <p>Which way is best to use ?</p>