I've tried for hours to figure this out, but can't get it...
3 tables...
Newsletter_Series, Newsletter_Subscribers, Newsletter_Subscriptions
I need to run a query to get all Newsletter_Series
which don't have Subscriptions for a particular Subscriber...
Primary Key Relationships:
- Newsletter_Series.Series_ID / Newsletter_Subscriptions.Series_ID
- Newsletter_Subscriptions.Subscriber_ID /
Newsletter_Subscribers.Subscriber_ID
Can't do subqueries (aaargh!), so I'm left with a join.
Something like,
<CFQUERY Name="GetSeries" Datasource="#DSN#">
Select newsletter_series.Series_ID,
newsletter_series.Series_Title,
from newsletter_series
left join
newsletter_subscriptions, newsletter_subscribers
on (newsletter_subscriptions.Subscriber_ID <>
'#CurrentSubscriber.Subscriber_ID#'
and newsletter_subscription.Series_ID <>
newsletter_series.Series_ID)
where newsletter_series.Series_ID is null
</CFQUERY>
I've tried a lot of variations and read the documentation, but can't get the
results...
Help, anyone?
Rick
Rick Faircloth
WhiteStoneMedia.com
--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.253 / Virus Database: 263.3.8 - Release Date: 6/30/2004
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
