declare @temp table(aa varchar(10),bb varchar(10))
Insert into @temp
select 'aa','bb'select * from @temp union select aa,bb from table1
Insert into @temp
select 'aa','bb'select * from @temp union select aa,bb from table1
调试欢乐多
union
select aa,bb
from (select 'aa','bb' union select aa,bb) table1 --这里将作为一个新表table1
union
select aa,bb
from (select 'aa','bb' ) table1 --这里将作为一个新表table1