Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!feed.news.nacamar.de!newsfeed.vmunix.org!news2.euro.net!195.129.110.15.MISMATCH!lnewspeer01.lnd.ops.eu.uu.net!lnewsifeed01.lnd.ops.eu.uu.net!bnewspost00.bru.ops.eu.uu.net!emea.uu.net!read.news.de.uu.net!not-for-mail Message-ID: <3DA55FC9.1050100@web.de> Date: Thu, 10 Oct 2002 13:08:57 +0200 From: Michael Gast User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-DE; rv:1.0.1) Gecko/20020823 Netscape/7.0 X-Accept-Language: de-de, de MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Query from SQL SErver References: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Lines: 33 NNTP-Posting-Host: 213.70.192.26 X-Trace: 1034248184 read.news.de.uu.net 184 213.70.192.26 X-Complaints-To: abuse@de.uu.net Xref: newsfeed1.easynews.com comp.databases.oracle.server:163711 X-Received-Date: Thu, 10 Oct 2002 04:09:41 MST (news.easynews.com) Hi Pablo, PABLO schrieb: > Hi, I am trying to migrate this query from SQL server to Oracle 9i and > I can not find a way to solve it. > > Does someone have and idea of how to do it ? > > Thanks a lot in advance. > Pablo > > UPDATE Table1 > SET FieldA = b.FieldB > FROM ( SELECT Exp as FIledB, Exp as FieldC FROM ... WHERE.... ) As B > WHERE Table1.FieldA <> b.FieldB > AND Table1.Field> >= b.fieldC Have a look in the SQL reference manual (a96540.pdf). There you will see, that the UPDATE statement does not contain a FROM construct. -- All emails sent to this address are never read and never will be answered. Sorry, but until someone cleans up the spam mess, that's the way it has to be. E-Mails, die direkt an diese Adresse geschickt werden, lese und beantworte ich nicht. Ich bedauere diesen Umstand sehr, kenne derzeit aber keine bessere Möglichkeit, um die Spam-Flut abzustellen. Mit freundlichen Grüßen / Best Regards Michael Gast SEPP MED GmbH