表A 表B
ID ANUM ID BNUM
1 10 1 10
2 10 2 10
3 10 4 10
希望得出结果
ID ANUM BNUM
1 10 10
2 10 10
3 10
4 10用语句 SELECT a.id, anum, bnum from a full outer join b on a.id= b.id
得出的结果是
1 10 10
2 10 10
3 10
10这个问题应该怎么修正? 急 谢谢指教
ID ANUM ID BNUM
1 10 1 10
2 10 2 10
3 10 4 10
希望得出结果
ID ANUM BNUM
1 10 10
2 10 10
3 10
4 10用语句 SELECT a.id, anum, bnum from a full outer join b on a.id= b.id
得出的结果是
1 10 10
2 10 10
3 10
10这个问题应该怎么修正? 急 谢谢指教
select tt.sid,
max(tt.anum) as anum,
max(tt.bnum) as bnum
from (
select a.aid as sid,
a.anum,
null as bnum
from A
union
select b.bid as sid,
null as anum,
b.bnum
from B
)tt
group by tt.sid;
RESULT: SID ANUM BNUM
---------- ---------- ----------
1 10 10
2 10 10
3 10
4 10