The problem with what you have below is the sub-select can only return a single value, my fetch returns more than 1. I believe the t-sql update-from can handle it but I am not certain as I have only used it in one-2-one conditions.
Oh well, grubby vb app to the rescue. -----Original Message----- From: John Singleton [mailto:[EMAIL PROTECTED] Sent: Friday, June 11, 2004 4:26 PM To: Kevin Wilson Cc: [EMAIL PROTECTED] Subject: Re: UPDATE FROM STATEMENT NOT SUPPORTED 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]
