运行了，就是没有数据，那位高人帮忙解决一下

[q_yanfei]

select
greatest(co.operatedate,co.startdate),
co.operatedate,
co.comcode,
co.riskcode,
co.othflag,
co.businessnature,
nvl(handler1code,agentcode),
co.policytype,
co.sumpremium,
co.sumamount,
co.underwritecode,
cc.carkindcode,
cc.brandname,
cc.usenaturecode,
cc.useyears,
cc.purchaseprice,
decode(cc.carkindcode,'H0',cc.toncount,'A0',cc.seatcount),
nvl(cc.seatcount,cc.toncount),
ts.businesssort,
ts.businesssource,
cs.TonCount,--船龄
cs.ShipCName,
ts.postcode,
decode(co.policytype,'19',pc.conveyance,'20',pc.conveyance),
count (*) as zs
from
prpcmainorigin co,
prpcitemcar cc,
prptinsured ts,
PrpCitemShip cs,
PrpCPmainCargo pc

where
co.policyno=cc.policyno and
co.proposalno=ts.proposalno and
co.policyno=cs.policyno and
co.policyno= pc.policyno
group by
greatest(co.operatedate,co.startdate),
co.operatedate,
co.comcode,
co.riskcode,
co.othflag,
co.businessnature,
nvl(handler1code,agentcode),
co.policytype,
co.sumpremium,
co.sumamount,
co.underwritecode,
cc.carkindcode,
cc.brandname,
cc.usenaturecode,
cc.useyears,
cc.purchaseprice,
decode(cc.carkindcode,'H0',cc.toncount,'A0',cc.seatcount),
nvl(cc.seatcount,cc.toncount),
ts.businesssort,
ts.businesssource,
cs.TonCount,
cs.ShipCName,
ts.postcode,
decode(co.policytype,'19',pc.conveyance,'20',pc.conveyance)

[limaowa]

朋友,直接这样给个SQL我们没有办法给你定位,
只能估计的说:
1\确实没有满足你的连接条件的数据记录存在
2\连接中的字段是否有数据类型不一致的问题,导致连接不通
3\查看你的prpcmainorigin 里的数据情况
4\把内连接改为左连接,
其实这样的问题不用慌,都是很简单的,耐心点都能解决的