Re: update SQL

Update statemet cannot have FROM clause. So, hte
modified statement is

UPDATE PS_PAYMENT SET ADJUST = 'N',
user_login_track_id = 1, 
payment_status_id = 1 
where PS_PAYMENT.PAYMENT_ID in (select PAYMENT_ID from
PS_PAYMENT_NETTED where  PAYMENT_NETTED_ID = 4);

try this
Mukund

> 
> Subject: update SQL
> From: "Manish Jain" <[email protected]>
> Date: Thu, 13 Feb 2003 19:03:25
> X-Message-Number: 1
> 
> 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 


__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com

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