求助:Oracle多表查询分页的小问题
请教各位:多表查询的sql语句该怎么写
SELECT a.flow_id,a.ry_id,a.ry_name,a.xb_id,a.mz_id,a.sfz_id,a.zy_id,a.xmjlzsbh,a.islocked,a.isQualified ,a.isInOffice ,a.isCancel,b.corp_id,a.szdwmc
FROM man_xmjl a,corp_sgqy b WHERE a.szqybm = b.corp_id(+) ORDER BY a.ry_id DESC
在线等,急用,谢谢!!!