workaround for outer join using filtering subquery

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 al.id, alm.idmember, al.listname
FROM addresslists AS al
LEFT OUTER JOIN
(SELECT idlist, idmember FROM addresslistmembers WHERE idmember = 4)
AS alm
ON al.id = alm.idlist


.

Relevant Pages

  • Re: workaround for outer join using filtering subquery
    ... 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.) ... FROM addresslists AS al ... idmember FROM addresslistmembers WHERE idmember = 4) ...
    (comp.databases)
  • Re: workaround for outer join using filtering subquery
    ... 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.) ... FROM addresslists AS al ... idmember FROM addresslistmembers WHERE idmember = 4) ...
    (comp.databases)
  • Re: workaround for outer join using filtering subquery
    ... 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.) ... FROM addresslists AS al ... idmember FROM addresslistmembers WHERE idmember = 4) ...
    (comp.databases)
  • Re: workaround for outer join using filtering subquery
    ... 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.) ... FROM addresslists AS al ... idmember FROM addresslistmembers WHERE idmember = 4) ...
    (comp.databases)
  • Re: Literaturreferenz "Approximativ stetig"
    ... Wie ist denn "approximativ stetig" definiert? ... Alm ... Prev by Date: ...
    (de.sci.mathematik)