现在我需要对一个数据窗口比较复杂的SQL语句需要做非常小的修改, 但是每次修改完,数据窗口返回都会出错. 我都不知道是怎么回事, 可能是公司PB版本问题，网络问题或者其他问题. 出现这样的问题还有什么方法可以修改数据窗口的SQL呢? 这么微小的修改都搞到我烦死了, 请指教指教,万分感激!!!!!!!
(想把(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'))
