RIGHT JOIN:
寫法一、
select * from
(select charg from ABC where charg is not null order by charg desc)a
,
(select aufnr ,anred from CDE)b
where a.charg(+)=(substr(b.aufnr,6))
寫法二、
select id from
ABC A RIGHT JOIN CDE B
ON a.ID=b.ID
意義:
依CDE的表格為準，只要CDE有的，全列出來
參考：http://www.cnblogs.com/helong/articles/2088535.html
