create table #yonghu(number int, money1 money) create table #addition1(number int, money2 money) create table #addition2(number int, money3 money)insert into #yonghu (number,money1) values(1,1) insert into #yonghu (number,money1) values(1,2) insert into #yonghu (number,money1) values(6,3) insert into #addition1 (number,money2) values(2,2) insert into #addition2 (number,money3) values(3,3) select T.number,T1.money1,T2.money2,T3.money3 from ( select number from #yonghu union select number from #addition1 union select number from #addition2 ) T left join #yonghu T1 on T.number=T1.number left join #addition1 T2 on T.number=T2.number left join #addition2 T3 on T.number=T3.numberdrop table #yonghu,#addition1,#addition2
select A.*,B.money2,C.money3 from yonghu A inner join addition B on A.number=B.number inner join addition C on A.number=C.number
select c.money3,d.money1,d.money2,colesec(c.number,d.number) as bumber from (select a.money1,b.money2,colesec(a.numeber,b.numeber) as number from a full outer join b on b.number=a.number) d full outer join c on c.number=d.number
create table #yonghu(number int, money1 money)
create table #addition1(number int, money2 money)
create table #addition2(number int, money3 money)insert into #yonghu (number,money1) values(1,1)
insert into #yonghu (number,money1) values(1,2)
insert into #yonghu (number,money1) values(6,3)
insert into #addition1 (number,money2) values(2,2)
insert into #addition2 (number,money3) values(3,3)
select T.number,T1.money1,T2.money2,T3.money3
from
(
select number
from #yonghu
union
select number
from #addition1
union
select number
from #addition2 ) T
left join #yonghu T1 on T.number=T1.number
left join #addition1 T2 on T.number=T2.number
left join #addition2 T3 on T.number=T3.numberdrop table #yonghu,#addition1,#addition2
inner join addition C on A.number=C.number