title: SELECT INTO USING UNION QUERY
body: <p>I want to create a new table in SQL Server with the following query. I am unable to understand why this query doesn't work.</p>
  
  <p>Query1: Works</p>
  
  <pre><code>SELECT * FROM TABLE1
  UNION
  SELECT * FROM TABLE2 
  </code></pre>
  
  <p>Query2: Does not Work. 
  Error: <code>Msg 170, Level 15, State 1, Line 7
  Line 7: Incorrect syntax near ')'.</code></p>
  
  <pre><code>SELECT * INTO [NEW_TABLE]
  FROM
  (
  SELECT * FROM TABLE1
  UNION
  SELECT * FROM TABLE2
  )
  </code></pre>
  
  <p>Thanks!</p>