UC知道高手帮我看看sql语句有问题不
来源：百度知道 编辑：UC知道 时间：2024/09/26 05:19:26
select 'CAFJ' as 承保公司代码,a.policyno as 保单号,b.licenseno as 车牌号,
(select codecname from prpdcode@caprod_link where codetype='LicenseKindCode' and codecode=b.LicenseKindCode) as 号牌种类,
b.EngineNo as 发动机号,b.FrameNo as 车架号,c.cs as 出险次数,a.startdate as 起保日期,a.enddate as 终保日期 from prpcmain@caprod_link a, PrpCitemCar@caprod_link b,
(select m.policyno,count(1) as cs,sum(n.sumpaid) as sumpaid from prplclaim@caprod_link m,prplcompensate@caprod_link n where
m.claimno=n.claimno
and claimdate>=date '2007-07-01' and canceldate is null group by m.policyno having sum(n.sumpaid)>0 ) c
where a.policyno=b.policyno and b.policyno=c.policyno
and b.licenseno like '闽AT%'
and a.comcode like '35%'
(select codecname from prpdcode@caprod_link where codetype='LicenseKindCode' and codecode=b.LicenseKindCode) as 号牌种类,
b.EngineNo as 发动机号,b.FrameNo as 车架号,c.cs as 出险次数,a.startdate as 起保日期,a.enddate as 终保日期 from prpcmain@caprod_link a, PrpCitemCar@caprod_link b,
(select m.policyno,count(1) as cs,sum(n.sumpaid) as sumpaid from prplclaim@caprod_link m,prplcompensate@caprod_link n where
m.claimno=n.claimno
and claimdate>=date '2007-07-01' and canceldate is null group by m.policyno having sum(n.sumpaid)>0 ) c
where a.policyno=b.policyno and b.policyno=c.policyno
and b.licenseno like '闽AT%'
and a.comcode like '35%'
select 'CAFJ' as 承保公司代码,a.policyno as 保单号,b.licenseno as 车牌号,
(select codecname from prpdcode@caprod_link where codetype='LicenseKindCode' and codecode=b.LicenseKindCode) as 号牌种类,
b.EngineNo as 发动机号,b.FrameNo as 车架号,c.cs as 出险次数,a.startdate as 起保日期,a.enddate as 终保日期 from prpcmain@caprod_link a, PrpCitemCar@caprod_link b,
(select m.policyno,count(1) as cs,sum(n.sumpaid) as sumpaid from prplclaim@caprod_link m,prplcompensate@caprod_link n where
m.claimno=n.claimno
and claimdate>= '2007-07-01' and canceldate is null group by m.policyno having sum(n.sumpaid)>0 ) c
where a.policyno=b.policyno and b.policyno=c.policyno
and b.licenseno like '闽AT%'
and a.comcode like '35%'
这样可以：
你把''2007-07-01'前面加个date当然报错了