title: how to add column while creating table using select query?
body: <p>I am creating table using following way:</p>
  
  <pre><code>CREATE TABLE test AS 
    SELECT    t1.column1, 
              t1.column2, 
              t1.column3, 
  
              t2.column4 , 
              t2.column6 , 
              t1.column8 
    FROM      table_1 t1
    JOIN table_2 t2 
    ON        t1.column1 = t2.column2 ;
  </code></pre>
  
  <p>after that I am adding column in newly created table using following <code>alter command</code></p>
  
  <pre><code>ALTER TABLE test ADD COLUMN New_column1 varchar NOT NULL DEFAULT 0,
                ADD COLUMN New_column2    varchar NOT NULL DEFAULT 0, 
                ;
  </code></pre>
  
  <p>Now I want to merge both query into One.</p>
  
  <p>How I can do that ?</p>
  
  <p>Thank You</p>