insert into newtable select * from ( select * from table1 union all select * from table2 union all select * from table3 ) a
select * into newtablename from ( select col1 ,col2...coln from table1 union all select col1 ,col2...coln from table2 union all select col1 ,col2...coln from table3 )
select * from
(
select * from table1
union all
select * from table2
union all
select * from table3
)
a
from (
select col1 ,col2...coln from table1
union all
select col1 ,col2...coln from table2
union all
select col1 ,col2...coln from table3
)