Query/Left Join problem

2001-02-15 Thread Roger Ramirez
Hi there. I'm having a problem with a couple of tables I'm using and finding some missing records and I was hoping someone could help me. Here is the setup. I have a table that is called "perms". Within here I have a bunch of columns, only 2 of which are important. ID which is an auto

RE: Query/Left Join problem

2001-02-15 Thread Quentin Bennett
newsletter_subscription.member_id0 AND (perms.id IS NULL OR mass_mail='No'); Does that give you what you need? Regards Quentin -Original Message- From: Roger Ramirez [mailto:[EMAIL PROTECTED]] Sent: Friday, 16 February 2001 08:34 To: MySQL List Subject: Query/Left Join problem Hi there. I'm having

RE: Query/Left Join problem

2001-02-15 Thread Roger Ramirez
Duh why didn't I think of that. Thank you graciously. :) -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 4:26 PM To: 'Roger Ramirez'; MySQL List Subject: RE: Query/Left Join problem Hi, Your left join tried to find members