Subqueries on MySQL 4.0.14-standard

[Damian Creedon]

Hello,
I am trying to run this query on MySQL 4.0.14-standard and it is not working, mainly due to the fact that the version of MYSQL does not support sub-queries. I need to re-write it using joins etc.. I have failed do do this and I am losing my mind....

Here is the SQL with the subquery, can someone help, please

SELECT * FROM contacts WHERE username = '[e-mail]' AND id NOT IN (SELECT contactid FROM groupmembers WHERE username = '[e-mail]' AND groupname='Family')

Basically get everything in the contacts table that does not have an entry in the groupmembers table for a particular user and group.