you can use
select addresses.id from addresses LEFT JOIN mlist ON
addresses.id=mlist.addr_id AND mlist.mlist_id=$mlist_id WHERE mlist.mlist_id
IS NULL
On Thu 27. September 2001 08:09, Adam Gintis wrote:
> I have the following table mlist:
>
> +--+-+
>
> | mlist_id | addr_id |
>
> +--+-+
>
> |1 | 1 |
> |2 | 2 |
> |2 | 3 |
> |1 | 3 |
>
> +--+-+
>
> This is the join table of my address book and my mailing lists. So person 1
> is in list 1, person 2 is in list 2, and person 3 is in both lists.
>
> What I want to do is get a list of everyone that is NOT in a certain list.
> In other words, if I'm editing list 1, I need a list of all the people in
> the address book that aren't in list 1 (person 2). If I'm editing list 2, I
> want person 1. I never want to see person 3, because he is already in both
> lists.
>
> I'm currently trying to do this with a statement like "SELECT * FROM mlist
> GROUP BY addr_id HAVING mlist_id != 'list I'm currently editing'". The
> problem is that group by addr_id keeps the first row's value for mlist_id.
> So when I'm editing list 2, it works. But when I'm editing list 1, person 3
> still shows up. If the last two rows were the other way around in the
> table, it would work for list 1 and not for list 2.
>
> So the question is, is there a command I can use to look through the
> aggregate set of mlist_id's, or is there another way to write this query?
>
> Thanks!
>
>
> ---
> Adam Gintis
> Vanderbilt University
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
