RE: A challenge I think

Thanks to all, it works fine. Regards John Berman -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: 06 February 2004 22:18 To: [EMAIL PROTECTED] Subject: Re: A challenge I think Hi, > Using MySQL 4x > I have two tables > Lists and members > Now fo

RE: A challenge I think

Or use an outer join with "where members.list_id is null", as was mentioned on the list earlier today. --Walt > -Original Message- > From: Martijn Tonies [mailto:[EMAIL PROTECTED] > Sent: Friday, February 06, 2004 3:18 PM > To: [EMAIL PROTECTED] > Subject

Re: A challenge I think

Hi, > Using MySQL 4x > I have two tables > Lists and members > Now for every list that a member is a member of there is list ID in the > members table so to query a members lists I would do the following > SELECT members.EmailAddr, members.ListID > > FROM members INNER JOIN lists ON members.ListI