update and select question

[黄高峰]

i use this mail first .

i have a problem in under sql program:


UPDATE
    NGLDENHDT
SET
    EDT_HUK_FLG = :EDT_HUK_FLG
WHERE
  KAI_CDE = :KAI_CDE
  AND EDT_NUM = (SELECT MAX(EDT_NUM)
                               FROM NGLDENHDT
                               WHERE KAI_CDE = :KAI_CDE_T1
                               AND EDT_NUM != '9999');

the error message was:

            You can't specify target table 'NGLDENHDT' for update in FROM
clause


what can i do ,help me ?


  thank you very much!!