--楼主是要这样的? select * from a union all select * from b --还是这样的? select * from a union select * from b
--try select isnull(T1.a,T2.a) , isnull(T1.b,T2.b) from T1 full join T2 on T1.a =T2.a and T1.b = T2.b
declare @T1 table(a datetime,b varchar(10)) insert into @T1 select getdate()-5,'a' insert into @T1 select getdate()-4,'b' insert into @T1 select getdate()-3,'c' --insert into @T1 select getdate()-2,'d' insert into @T1 select getdate()-1,'e'declare @T2 table(a datetime,b varchar(10)) insert into @T2 select getdate()-5,'a' --insert into @T2 select getdate()-4,'b' insert into @T2 select getdate()-3,'c' insert into @T2 select getdate()-2,'d' insert into @T2 select getdate()-1,'e'select * from @T1 union select * from @T2 /* a b ----------------------- ---------- 2008-06-20 13:09:00.717 a 2008-06-21 13:09:00.717 b 2008-06-22 13:09:00.717 c 2008-06-23 13:09:00.717 d 2008-06-24 13:09:00.717 e */ select isnull(T1.a,T2.a) as a, isnull(T1.b,T2.b) as b from @T1 T1 full join @T2 T2 on T1.a =T2.a and T1.b = T2.b /* a b ----------------------- ---------- 2008-06-20 13:08:10.810 a 2008-06-21 13:08:10.810 b 2008-06-22 13:08:10.810 c 2008-06-24 13:08:10.810 e 2008-06-23 13:08:10.810 d */
--楼主是要这样的?
select * from a
union all
select * from b
--还是这样的?
select * from a
union
select * from b
select isnull(T1.a,T2.a) , isnull(T1.b,T2.b) from T1 full join T2 on T1.a =T2.a and T1.b = T2.b
insert into @T1 select getdate()-5,'a'
insert into @T1 select getdate()-4,'b'
insert into @T1 select getdate()-3,'c'
--insert into @T1 select getdate()-2,'d'
insert into @T1 select getdate()-1,'e'declare @T2 table(a datetime,b varchar(10))
insert into @T2 select getdate()-5,'a'
--insert into @T2 select getdate()-4,'b'
insert into @T2 select getdate()-3,'c'
insert into @T2 select getdate()-2,'d'
insert into @T2 select getdate()-1,'e'select * from @T1 union select * from @T2
/*
a b
----------------------- ----------
2008-06-20 13:09:00.717 a
2008-06-21 13:09:00.717 b
2008-06-22 13:09:00.717 c
2008-06-23 13:09:00.717 d
2008-06-24 13:09:00.717 e
*/
select isnull(T1.a,T2.a) as a, isnull(T1.b,T2.b) as b
from @T1 T1 full join @T2 T2 on T1.a =T2.a and T1.b = T2.b
/*
a b
----------------------- ----------
2008-06-20 13:08:10.810 a
2008-06-21 13:08:10.810 b
2008-06-22 13:08:10.810 c
2008-06-24 13:08:10.810 e
2008-06-23 13:08:10.810 d
*/