How to update from other table?

[William IT]

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?


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]