From: John Singleton (jsingletjohnsingleton.com)
Date: Fri Jun 11 2004 - 16:26:03 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

Kevin.Wilsoncomtrol.com 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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]