UPDATE CW_PZ1_CSH SET CW_PZ1_CSH.NCCFLAG=NULLfrom CW_PZ1_CSH INNERJOIN CSH_ztpzkey
ON CSH_ztpzkey.zt_no =CW_PZ1_CSH.ZT_NO AND CSH_ztpzkey.pz_key = CW_PZ1_CSH.PZ_KEY
AND CW_PZ1_CSH.NCCFLAG ISNOTNULL
正确的SQL
UPDATE CW_PZ1_CSH
SET CW_PZ1_CSH.NCCFLAG=(select nccflag from CSH_ztpzkey where CSH_ztpzkey.zt_no =CW_PZ1_CSH.ZT_NO AND CSH_ztpzkey.pz_key = CW_PZ1_CSH.PZ_KEY )whereexists(select1from CSH_ztpzkey where CSH_ztpzkey.zt_no =CW_PZ1_CSH.ZT_NO AND CSH_ztpzkey.pz_key = CW_PZ1_CSH.PZ_KEY )AND CW_PZ1_CSH.NCCFLAG ISNOTNULL