Error message of null values

(Ken Milligan) keep getting the error message of null values not allowed in column or variable ZORD#T for SQL update (using V5R3): UPDATE Z9519 A SET A.ZORD#T = (SELECT COALESCE( B.ZORD#T, A.ZORD#T ) FROM Z9517 B WHERE A.ZADES1 = B.ZADES1 AND A.WHS=B.WHS) (R)

Read More - Register for Free Membership