Union Question

[KiwiGuy]

Hey All,

How do i use the results from a Union to insert into a tempory table?

i thought it should be

Select *
Into #tmptable
from
(select a from b
union
select a from c)

Help!!1

 

[oldduffer]

Try this

you might find it is easier to perform an insert into and have your select list subsequent to that but this should work

Select a
into #temptable
from b
union
select a from e