"William IT" <[EMAIL PROTECTED]> wrote: > I try convert this MS SQL Statement but an error occurs: > > UPDATE a SET a.ACCOUNT_CODE=b.ACCOUNT_CODE > FROM a,b > WHERE a.ACCODE=b.ACCOUNT_OLD > > Is there any syntax doing same as above? > Yes. From v4.0.4 you can do:
UPDATE a, b SET a.ACCOUNT_CODE=b.ACCOUNT_CODE WHERE a.ACCODE=b.ACCOUNT_OLD UPDATE syntax is described at: http://www.mysql.com/doc/en/UPDATE.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]