![]() |
#2
yihuizeng2007-08-09 09:41
|

(想把(select euru.huwdcdte from euru where euru.clmnum=eurt.aplnum) as huwdcdte,
修改成select euru.huwdcdte from euru where euru.clmnum=eurd.clmnum)
select eurd.chdrnum,eurd.crtable,
(select notedesc from IVRCRTB where crtable=eurd.crtable),
eurt.notedesc01,eurt.notedesc02,eurt.notedesc03,
eurt.notedesc04,eurd.mind,eurd.effdate,
(select euru.flag01 from euru where euru.clmnum=eurd.clmnum) as flag01,
(select euru.huwdcdte from euru where euru.clmnum=eurt.aplnum) as huwdcdte,
(select EUITMDESC from EUFKPKY WHERE EUFKPKY.EUTBLCODE = 'UW2' and EUTBLITEM=eurd.mind)
from eurd left join eurt on eurd.clmnum= eurt.aplnum
and eurd.chdrnum= eurt.chdrnum and eurd.life= eurt.life
and eurd.jlife= eurt.jlife and eurd.coverage= eurt.coverage
and eurd.rider= eurt.rider where (eurd.mind not in ('1','2',''))
and eurd.chdrnum in (SELECT LIFECLT.CHDRNUM
FROM CLNTCLN,LIFECLT WHERE ( CLNTCLN.CLNTNUM = LIFECLT.LIFCNUM ) and
(( CLNTCLN.CLNTNUM IN (:clntnum) ) AND LIFECLT.VALIDFLAG = '1'))