By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,964 Members | 1,420 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,964 IT Pros & Developers. It's quick & easy.

workaround for outer join using filtering subquery

P: n/a
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

Sep 24 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.