Kevin,
After looking at what that statment does in MS SQL Server, I think this is the syntax you are looking for:
UPDATE <TABLE> SET <column_name> = <subquery>| (<column_name>,...) = <subquery> WHERE <CONDITIONS>
Hope that helps. (That update from statement is wild...)
Cheers,
JLS
[EMAIL PROTECTED] wrote:
Unable to do mass update from a table using:
UPDATE <TBL> SET <COL> = 'X' FROM <TBL A>, <TBL B> WHERE <CONDITION(S)>
Get "Invalid end of SQL statement." on the FROM keyword. This is a real handy item to have (use it in MS SQL Server). It may be a non-standard T-SQL extension but I am not sure. Nonetheless, I would think that adding this to your support sql would make many very happy.
Cheers
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
