Simple Subquery question

[SmileeTiger]

Does anyone see anything wrong with:

SELECT Notes FROM BT_Messages WHERE (Who = "USR_username1") OR (Who = "USR_ALL") OR (Who IN (SELECT GroupID FROM BT_Membership WHERE UserID = "username2")) GROUP BY UID,Notes ORDER BY UID

 

[sleipnir214]

It depends. What version of MySQL are you running?

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[SmileeTiger]

I'm currently running 4.0.

 

[SmileeTiger]

4.018 for windows to be exact

 

[sleipnir214]

The type of subquery you are using:

...IN (SELECT GroupID FROM BT_Membership WHERE UserID = "username2")...

Is only supported in MySQL version 4.1 and higher. The MySQL online manual has a page on rewriting the query

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[SmileeTiger]

That will teach me to not read everything in the docs.

SELECT message FROM BT_MESSAGES, BT_MEMBERSHIP WHERE (BT_MESSAGES .Who = "USR_username1") OR (BT_MESSAGES.Who = "USR_ALL") OR (BT_MESSAGES.Who = BT_MEMBERSHIP.GroupID AND BT_MEMBERSHIP.GroupID = "username2") ;

Should work just fine.

Thanks for the help!