select a.policyno,a.inputtime,a.startdate,b.licenseno,a.projectcode,b.MonopolyCode,a.comcode,b.carkindcode,b.usenaturecode,
c.insuredname as cz,e.insuredname as tbr,d.insuredname as bbxr,a.othflag,a.agentcode,a.handlercode,a.sumnetpremium,
f.costrate,f.costfee,a.sumTaxPremium,g.carchecker
from prpcmain a,prpcitem_car b,prpcinsured c,prpcinsured d,prpcinsured e,prpcmain_car g,outer prpcagent f
where a.proposalno=b.proposalno
and a.proposalno=c.proposalno
and a.proposalno=d.proposalno
and a.proposalno=e.proposalno
and a.proposalno=f.proposalno
and a.proposalno=g.proposalno
and c.insuredflag[3]='1'
and d.insuredflag[2]='1'
and e.insuredflag[1]='1'
and a.comcode[1,4]='6229'
and a.policyno is not null
and a.policyno!=''
and a.inputtime>=date('2022-02-01')
and a.inputtime<date('2022-03-01') into temp wsl1 with no log;
select a.*,b.userclassificationcode from wsl1 a,outer gs6200ims3gdb@gs_6200_cb_kl:utiiservicemanager b where a.carchecker=b.usercode;
报错是什么?贴图
连接 gs_6200_cb_kl 这个库出错了?