Oracle联合多个子查询(inner join)

 

select aaa.*,bbb.xh from

(select xn,xq,kcdm,kcmc,xf,xkkh,kcxz from jxrwbview where xn='2017-2018' group by xn,xq,kcdm,kcmc,xf,xkkh,kcxz ) aaa

inner join
(select  distinct xkkh,xh from xsxkb where xn='2017-2018' ) bbb

on aaa.xkkh=bbb.xkkh

posted @ 2018-10-10 10:03 emanlee 阅读(...) 评论(...) 编辑 收藏