MySQL Forums
Forum List  »  Microsoft SQL Server

Recommended approach for UPDATE referencing same table?
Posted by: David Wynter
Date: May 20, 2005 04:25AM


Have been converting lots of qeuries from a Servlet application using SQL Server. The inability for MySQL 4.1.11 to reference the same table being updated in a sub query is a real pain. We have a number of self referential tables. What is the recommended method of doing this type of query?

UPDATE tabl1 ce1, tabl1 ce2 SET ce1.Previous_Event_Id = ce2.Event_Id
WHERE ce2.Event_Id = (SELECT MAX(ce.Event_Id) FROM tabl1 ce
WHERE ce1.Div_Market_Lvl_Id = ce.Div_Market_Lvl_Id AND ce1.RIC = ce.RIC
AND ce1.Previous_Event_Id IS NULL)



Options: ReplyQuote

Written By
Recommended approach for UPDATE referencing same table?
May 20, 2005 04:25AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.