连接查询问题！

[T8421]

有A,B表
表A数据
Rq Money1
2003-01-01 100.00
2003-01-02 110.00
2003-01-06 200.00
2003-01-07 100.00

表B数据
Rq Money2
2003-01-01 170.00
2003-01-02 190.00
2003-01-03 140.00
2003-01-04 130.00
2003-01-05 120.00

如何通过Sql语句使产生如下结果：
rq money1 money2
2003-01-01 100.00 170.00
2003-01-02 100.00 190.00
2003-01-03 0.00 140.00
2003-01-04 0.00 130.00
2003-01-05 0.00 120.00
2003-01-06 200.00 0.00
2003-01-07 100.00 0.00

[black_snail]

select a.rq , a.money1 , nvl(b.money2,0)
from a,b
where a.rq = b.rq(+)
Union
select b.rq , nvl(a.money1,0) , b.money2
from a,b
where a.rq(+) = b.rq

[snowy_howe]

select a.rq,nvl(a.money1,0),nvl(b.moner2,0) from A a,B b,
　　　　(select rq from A union select rq from B) c
where c.rq=a.rq(+) and c.rq = b.rq(+);

[Lastdrop]

你怎么发了两个一模一样的帖子？
瞧瞧我的回答吧。 ：）

[snowy_howe]

select c.rq,nvl(a.money1,0),nvl(b.money2,0) from A a,B b,
　　　　(select rq from A union select rq from B) c
where c.rq=a.rq(+) and c.rq = b.rq(+);

[benxie]

Lastdrop(空杯) (对呀,这个问题我都会了.呵