While I don't have a MaxDB instance I can test this on, I have a couple ideas for you. (By the way I have been using the FROM clause in MSSQL Updates for a long time and don't see how you can live without them.) In Access you can put the join statement in the table name spot, such as "UPDATE TABLE1,TABLE2 ... Another possibility would be to create the joined expression in () and make the statement something like Update (selectquery) set fieldA=FieldB ...
Just some thought. Please let us know how it goes. ________________________________________________________________________________ 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] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
