MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

UPDATE query
Posted by: Tobbe
Date: March 26, 2005 05:21AM

I have to convert this query. It has to work in versions lower then 4.1

strSQL="UPDATE tbltrans SET tbltrans.otherID = "& psID &" WHERE otherEmail in (SELECT Email FROM tblUser WHERE userID = "& psID &")"

How do I do?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
UPDATE query
Tobbe
March 26, 2005 05:21AM
Re: UPDATE query
Shantanu Oak
March 26, 2005 09:48AM
Re: UPDATE query
Tobbe
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.