这个sql你来错咧？？？

[jnkaixin2009]

select rownum as xh,t.* from wskj_jkpzxx t where
nsrsbh in (
select nsrsbh from qy_nsrxx qy, qx_users users , qx_user_gw ug, qx_gw gw , dm_swjg jg where substr(qy.zgswjg,1,jg.yxws) = substr(jg.swjg_dm,1,jg.yxws) and jg.swjg_dm = gw.qx_swjg_dm and gw.gw_dm = ug.gw_dm and ug.userid = users.userid and users.name = 'admin '
)
EXT_CDBZ='1' and EXT_ZPBZ='0' and t.SSQQ >='2006-01-01' and t.SSQZ <='2010-01-31' ;


这个sql，提示没有正确结束。SQL command not properly ended

但是那里错了奥

[suiziguo]

select rownum as xh,t.* from wskj_jkpzxx t where
nsrsbh in (
select nsrsbh from qy_nsrxx qy, qx_users users , qx_user_gw ug, qx_gw gw , dm_swjg jg where substr(qy.zgswjg,1,jg.yxws) = substr(jg.swjg_dm,1,jg.yxws) and jg.swjg_dm = gw.qx_swjg_dm and gw.gw_dm = ug.gw_dm and ug.userid = users.userid and users.name = 'admin '
)
AND EXT_CDBZ='1' and EXT_ZPBZ='0' and t.SSQQ >='2006-01-01' and t.SSQZ <='2010-01-31' ;

[爱吃芒果的猴子]

少个and;

select rownum as xh,t.* from wskj_jkpzxx t where 
nsrsbh in (select nsrsbh from  qy_nsrxx  qy, qx_users users , qx_user_gw ug, qx_gw gw , dm_swjg jg where substr(qy.zgswjg,1,jg.yxws) = substr(jg.swjg_dm,1,jg.yxws) and jg.swjg_dm = gw.qx_swjg_dm and gw.gw_dm = ug.gw_dm and ug.userid = users.userid and users.name = 'admin ') 
  and      EXT_CDBZ='1' and EXT_ZPBZ='0' and t.SSQQ >='2006-01-01' and t.SSQZ <='2010-01-31' ;