关于outer join

select t1.rp_no,count(*) from zgire t1,zgwsg t2
where t1.rp_no = t2.rp_no(+) and t1.rp_type = t2.rp_type(+)
group by t1.rp_no
order by t1.rp_no;

等价于

select t1.rp_no,count(*) from zgire t1
left outer join
zgwsg t2
on t1.rp_no = t2.rp_no and t1.rp_type = t2.rp_type
group by t1.rp_no
order by t1.rp_no;

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/96210/viewspace-1056783/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/96210/viewspace-1056783/