ora-00907错误问题，求教。
以下是出错代码：
select e.*, d.*
from (select b.nsrmc, b.hy_dm, c.nsrzg_dm
from dj_nsrxx b
left join rd_nsrzg c
on b.nsrsbh = c.nsrsbh) e,
(select a.nsrsbh, sum(a.xssr) as xssr_hz, sum(a.se) as se_hz
from sb_zsxx a
where a.nsr_swjg_dm = '153'
and a.yzskbz = 'Y'
and a.hzjksbz = 'N'
and a.sssq_q >= to_date('20090321', 'yyyymmdd')
and a.sssq_q <= to_date('20100320', 'yyyymmdd')
and a.sksx_dm < '51'
and a.sksx_dm <> '22'
and a.sb_tzlx_dm = '0'
and a.zsxm_dm = '01'
and a.zspm_dm <> '9900'
group by a.nsrsbh) d
where e.nsrsbh = d.nsrsbh
order by d.se_hz desc
在第4行left处报错，曾经做成：
select e.*, c.nsrzg_dm
(select b.nsrmc, b.hy_dm，d.*
from dj_nsrxx b,
(select a.nsrsbh, sum(a.xssr) as xssr_hz, sum(a.se) as se_hz
from sb_zsxx a
where a.nsr_swjg_dm = '153'
and a.yzskbz = 'Y'
and a.hzjksbz = 'N'
and a.sssq_q >= to_date('20090321', 'yyyymmdd')
and a.sssq_q <= to_date('20100320', 'yyyymmdd')
and a.sksx_dm < '51'
and a.sksx_dm <> '22'
and a.sb_tzlx_dm = '0'
and a.zsxm_dm = '01'
and a.zspm_dm <> '9900'
group by a.nsrsbh) d
where e.nsrsbh = d.nsrsbh
order by d.se_hz desc) e
left join rd_nsrzg c
on e.nsrsbh = c.nsrsbh
依然出错，不知原因，求教。
[解决办法]
发到Oracal里。
http://forum.csdn.net/BList/Oracle
