三表显示问题，在线等
select * from A
select * from B
select * from C
我要这样显示：
A AA B C
1 11 B C
1 11 b1 C1
1 11 B2 null
第一个表只能有一条记录。。但B跟C。可以变。。。
[解决办法]
create table A(A int, AA int)
create table B(B varchar(5), A int)
create table C(C varchar(5), A int)
insert into A
select 1,11
insert into B
select 'B',1 union all
select 'b1',1 union all
select 'B2',1
insert into C
select 'C',1 union all
select 'c1',1
select isnull(t1.A,t2.A) 'A',
isnull(t1.AA,t2.AA) 'AA',
t1.B,
t2.C
from
(select x.A,x.AA,y.B,row_number() over(order by getdate()) 'rn'
from A x left join B y on x.A=y.A) t1
full join
(select x.A,x.AA,z.C,row_number() over(order by getdate()) 'rn'
from A x left join C z on x.A=z.A) t2 on t1.rn=t2.rn
/*
A AA B C
----------- ----------- ----- -----
1 11 B C
1 11 b1 c1
1 11 B2 NULL
(3 row(s) affected)
*/
