Re: Confusing SELECT statement

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 |

Confusing SELECT statement

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 i