Hi

Using MySql 4.x and need some help with a query

There are two tables

Lists
Which holds list name +other stuff

Members
Which holds list name from above, email address + other stuff


I want to list all the lists and then which lists a member is associated
with.

Eg

List1 - Member
List2 - Not a Member
List3 - Member

I can do a query that show the lists some is a member or a separate query to
show which they are not a member of but not a query to bring the whole thing
together


Pointers Appreciated.

Regards


John Berman





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to