3, when the select in an update statement, can't get the warning 01003. ij(CONNECTION1)> UPDATE APP.EMP T1 SET SALARY = ( SELECT AVG ( T2 . SALARY ) FRO M APP.EMP T2 ) WHERE WORKDEPT = 'D21' AND SALARY < ( SELECT AVG ( T3 . SALARY ) FROM APP.EMP T3 ); 7 rows inserted/updated/deleted
The lack of the warning seems incorrect to me. But I'm not sure if this behavior is governed by the SQL Standards or not. thanks, bryan
