declare @t table(a int,b int,c int) insert into @t select 1,2,3 union all select 2,3,4declare @a table(f int,e int,k int) insert into @a select 4,3,6 union all select 8,6,5select a as N from @t union all select f from @a --这样?
select a as n from a union all select f as n from b
select a as n from a union all select f as n from b
select a as n from a union all select f as n from b
insert into @t select 1,2,3
union all select 2,3,4declare @a table(f int,e int,k int)
insert into @a select 4,3,6
union all select 8,6,5select a as N from @t
union all
select f from @a
--这样?
union all
select f as n from b
union all
select f as n from b
union all
select f as n from b