Paul
Sorry to be a pain. I'm not sure that I understand Select an extra column in each SELECT. SELECT "member", ... UNION SELECT "non-member", ... Regards John Berman -----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: 29 February 2004 03:11 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Query Help At 2:45 +0000 2/29/04, John Berman wrote: >Got it working at last > >SELECT lists_.DescShort_ FROM lists_ WHERE (((lists_.Name_) Not In (select >members_.List_ from members_ where members_.EmailAddr_ like ('"& em & >"')))) union SELECT lists_.DescShort_ FROM members_ INNER JOIN lists_ ON >members_.List_ = lists_.Name_ WHERE (members_.EmailAddr_ = ('"& em & "')) > >My only problem being it now lists the lists Im not a member of and the ones >I am a member of - how on earth do I show on screen which is which ? Maybe: Select an extra column in each SELECT. SELECT "member", ... UNION SELECT "non-member", ... -- 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]