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
>
&g
=perms.id
WHERE newsletter_subscription.member_id<>0 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 pr
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 incremen
