Re: update SQL

The SQL working perfect in SQL Server and Sybase. 

How do you manage to update if you need update in one table based on the
reference of other table?

-----Original Message-----
From: Greg Griffiths [mailto:[email protected]] 
Sent: Thursday, February 13, 2003 4:51 PM
To: Oracle
Subject: [oracle] Re: update SQL

This looks more like a SELECT statement starting with the word UPDATE
than 
an Oracle update statement, check the syntx, I think that you can only
do a 
single table per query :

UPDATE <table name> SET <fieldname1> = <fieldvalue1> , <fieldname n> = 
<fieldvalue n> WHERE <fieldname1> = <fieldvalue1> , <fieldname n> = 
<fieldvalue n>

At 19:03 13/02/03 +0000, you wrote:
>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.unsub%%.




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


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