Re: UPDATE problem - FROM Clause not supported in Oracle

Dsriva, I do not believe that the FROM clause is part of the ANSI standard for an UPDATE statement. Regardless, I believe you want something like the following:

update field_char f
set maxLength = 254
where f.fieldid in ('2','4','5','101',117','118') and exists (select s.schemald

                 from arschema s
                 where s.schemald = f.schemald
                 and s.schema_type = 1)

You might want to try this version in SQL Server.

HTH -- Mark D Powell -- Received on Tue Jul 26 2005 - 15:12:07 CDT