workaround for outer join using filtering subquery

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

I'm using mysql 4.0.x, which does not allow the following query (which works
fine in 4.1).  Is there any way I can issue a single query to achieve the
same results?  (I want a list of all records from table al, nulled where
there is no match in table alm, which has been filtered.  Without a
subquery, the filtering occurs after the outer join, and for one specific
row from alm, I only see the nonmatching records from al where NO other alm
record matches.)

SELECT, alm.idmember, al.listname
FROM addresslists AS al
        (SELECT idlist, idmember FROM addresslistmembers WHERE idmember = 4)
AS alm
    ON = alm.idlist

Site Timeline