Using WHERE fieldName IN... 1

[XgrinderX]

I cannot get the following query to run:

SELECT * FROM tblMessages WHERE iMessageID IN (SELECT iMessageID FROM tblMessageTo WHERE iUserID = 1) AND iFolderID = 1 ORDER BY dtSent DESC

I can execute queries like this all day long in MS SQL, what am I doing wrong?

-Greg

 

[TonyGroves]

Sub-queries are supported in MySQL from version 4.1 onwards. Maybe you are using an earlier version.

It should be possible to rephrase that query as a join.

 

[XgrinderX]

UGH! You're right. We have version 4.0.18. I am a total rookie with MySQL installations - can I just download the new version and install it over the top of the one we have?

 

[TonyGroves]

That should be no problem. The table formats are the same, as far as I remember.

 

[XgrinderX]

I got it done, upgraded to 4.1.13 and now it's all happy! Thanks so much!