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

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 Received on Tue Dec 06 2005 - 17:45:40 CST