A challenge I think

[John Berman]

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.ListID = lists.ListID

WHERE (((members.EmailAddr)="[EMAIL PROTECTED]"));

 

So I get say

 

[EMAIL PROTECTED] 3

[EMAIL PROTECTED] 2

[EMAIL PROTECTED] 44

 

And it works fine, but now I want to find which lists I'm not a member of
and would appreciate some help.

 

Ideally I would change the way the system works but that is not an option

 

 

Regards

 

John Berman