Update from other table

[William IT]

Does MySQL support update from other table?

I run this query and get error:

    UPDATE TableA SET Division=TableB.Division
    FROM TableB 
    WHERE TableA.Code=TableB.Code

Thanks.


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