2008-07-24 14:36:22 / Oracle开发
select yhxxcp_ssjl,dlgh_mc,xys,jcs,njc,tj,cj from (select yhxxcp_ssjl,dlgh_mc,(select count(*) from xygl_yhxxcp a,dlgh b where b.dlgh_gh=a.yhxxcp_fpr and b.dlgh_mc=d.dlgh_mc and a.yhxxcp_ssjl=c.yhxxcp_ssjl and a.yhxxcp_ibss='已续约' ) as xys,(select count(*) from xygl_yhxxcp e,dlgh f where f.
查看(744)
评论(25)