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
Hi,
Your left join tried to find members in newsletter_subscriptions that don't
exist in perms.
How about they exist, but are 'No'?:
SELECT newsletter_subscription.member_id
FROM newsletter_subscription LEFT JOIN perms ON
newsletter_subscription.member_id=perms.id
WHERE newsletter_subscription.
