nested queries

[Anon]

I'm using a version of MySQL that does not support subselects. I need something that will perform the following query:

SELECT username FROM members WHERE referer IN (SELECT id FROM members WHERE referer = 5);

The query is selecting all the indirect referrals for a specific member (all of the referers' referrals). The only other way I have been able to do this was a huge workaround (one query to get all the direct referral ID's, create a string out of it, then use that in another query).

TIA!

[[deleted]]

"a huge workaround (one query to get all the direct referral ID's, create a string out of it, then use that in another query). "

I'm affraid that that is just about the fastest way to do it in MySQL. MySQL sucks.

[Anon]

SELECT m1.username FROM members m1
inner join members m2
on m1.referer = m2.id
WHERE m2.referer = 5