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
Have you tried using a UNION of the two queries?
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
