update SQL

"Manish Jain" <[email protected]> Thu, 13 Feb 2003 19:03:25

Newsgroups	gmane.comp.db.oracle.devel
Message-ID	<LYRIS-1796914-873104-2003.02.13-18.48.16--gcdod-oracle#[email protected]>

Hi, 
I have one problem while executing the update statement as per my 
knowledge it should in the SQL server/ sybase but not sure about Oracle 
and its not working Can anybody can help me :
Here is my update statement


UPDATE PS_PAYMENT SET ADJUST = 'N', user_login_track_id = 1, 
payment_status_id = 1 FROM PS_PAYMENT PS,PS_PAYMENT_NETTED NET  WHERE 
NET.PAYMENT_ID = PS.PAYMENT_ID AND NET.PAYMENT_NETTED_ID = 4


error is :
ERROR at line 1:
ORA-00933: SQL command not properly ended

I will appreciate for quick reply.

Thanks
Manish 
---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].