Re: Basic Issue: Update query based on two tables not working! Any help appreciated!

<deepankar_at_hotmail.com> wrote in message news:1133912740.610772.258580_at_g49g2000cwa.googlegroups.com...
>
>
> I have a update query that is not running, and is giving me a strange
> error:
>
>
> ORA-00933: SQL Command not properly ended
>
> The Update Query is based on two tables, and that is what is causing
> the issue, I guess.
>
>
>
> UPDATE tableA
> SET tableA.PLAN_TYPE = 'L'
> FROM from tableB B, tableA A
> WHERE
> (A.OR_ID = B.OR_ID AND
> A.DS_ID = B.DS_ID)
>
>
> Any help is appreciated a lot.
>
> Thanks
> - Deepso
>

it appears that you may be using SQL Server syntax instead of Oracle syntax

++ mcs Received on Tue Dec 06 2005 - 21:00:09 CST