MySQL Forums
Forum List  »  Newbie

Re: UPDATE query
Posted by: Shantanu Oak
Date: March 26, 2005 09:48AM

I am not sure, but this may work...

UPDATE tbltrans
INNER JOIN tblUser
ON tbltrans.otherEmail = tblUser.Email
SET tbltrans.otherID = "& psID &"

Options: ReplyQuote


Subject
Written By
Posted
March 26, 2005 05:21AM
Re: UPDATE query
March 26, 2005 09:48AM
March 27, 2005 03:08PM


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.