Re: Migrating from SQL server

PABLO wrote:

> 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

UPDATE table1
SET FieldA = SELECT fieldB FROM ...

Daniel Morgan Received on Wed Oct 09 2002 - 12:29:53 CDT