[Resolved] Invalid MySQL Statement

[erikwebb]

I am using a SQL query which is apparently invalid, but I cannot see why. Here is the query:

SELECT email
FROM mls_member
WHERE active = 'true' AND id IN (
SELECT DISTINCT member_id
FROM mls_listlink
WHERE list_id = '1' OR list_id = '3' ) 

I have tried it using the new MySQL 4.0 subquery (I have v. 4.0 installed) syntax also, but it returns the exact same error:

SELECT email
FROM mls_member
WHERE active = 'true' AND id = (
SELECT DISTINCT member_id
FROM mls_listlink
WHERE list_id = '1' OR list_id = '3' ) 

And here is the error that phpMyAdmin returns:

You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the
right syntax to use near 'SELECT  DISTINCT member_id

[BlueMeteor]

mysql not support sub-query now

[erikwebb]

You're right, my bad. Can you help me somehow turn this into a basic join though? If you can't understand my statement, let me know.

[erikwebb]

Oops, I figured it out. If anyone wants to know, my solution is

SELECT DISTINCT email FROM mls_listlink, mls_member
WHERE active = 'true' AND mls_member.id = mls_listlink.member_id AND
mls_listlink.list_id = '1' OR mls_listlink.list_id = '3'