FW: update and select question

[J.R. Bullington]

http://dev.mysql.com/doc/mysql/en/update.html
(B
(BSee the last line on the page. You cannot, in the most current stable
(Bversion of MySQL, SELECT from the table you are trying to UPDATE.
(B
(BJ.R. 
(B
(B-----Original Message-----
(BFrom: $B2+9bJv(B [mailto:[EMAIL PROTECTED]
(BSent: Tuesday, April 26, 2005 11:26 PM
(BTo: mysql@lists.mysql.com
(BSubject: update and select question 
(B
(B
(Bi use this mail first .
(B
(Bi have a problem in under sql program:
(B
(B
(BUPDATE
(B    NGLDENHDT
(BSET
(B    EDT_HUK_FLG = :EDT_HUK_FLG
(BWHERE
(B  KAI_CDE = :KAI_CDE
(B  AND EDT_NUM = (SELECT MAX(EDT_NUM)
(B                               FROM NGLDENHDT
(B                               WHERE KAI_CDE = :KAI_CDE_T1
(B                               AND EDT_NUM != '9999');
(B
(Bthe error message was:
(B
(B            You can't specify target table 'NGLDENHDT' for update in FROM
(Bclause
(B
(B
(Bwhat can i do ,help me ?
(B
(B
(B  thank you very much!!

smime.p7s
Description: S/MIME cryptographic signature