Save Query Result as a New Table while using Union All 1

[SDB15]

I'm taking data from several tables (unlinked) and using union all to combine it all into one massive table. The query runs perfectly now but I cannot save it to a new table because syntax requires into to be placed after SELECT but before FROM. Is there any way to do this using a stored proceedure or maybe an INSERT command?

Thanks

 

[RiverGuy]

You mean like this?

SELECT * INTO NewTableName

FROM

(
  SELECT * FROM Table1
  UNION ALL
  SELECT * FROM Table2
) x

 

[SDB15]

Wow, that was a lot easier than I thought it would be. Thanks!
What is the purpose of the 'x' at the end? I know it won't work without it but I've never seen that before.

 

[checkai]

You need a table alias when using the UNION ALL

 

[markros]

Correction - you need a table alias when you're using derived table.

 

[RiverGuy]

The 'x' could be anything. It's just a temporary name for the derived table as they said.