> Your query below worked...I tried almost the exact
> same version, but I don't
> think I tried the WHERE clause that you used...and
> it's the last line that
> gives trouble logically...
>
> "WHERE newsletter_subscriptions.Subscriber_ID IS
> NULL"
That's actually in the examples on the page I referred
to. It functions as the logical equivalent of a NOT IN
if you're using a subquery.
> I've got to just sit and ponder the logic of the
> that statement in relation
> to the join. I use joins very seldom, so they give
> me fits every time I
> have
> to use one...
>
> But that's enough rambling!
> Thanks for the solution!
>
> Rick
> -----Original Message-----
> From: I-Lin Kuo [mailto:[EMAIL PROTECTED]
>
>
> MySql now supports subqueries:
> http://dev.mysql.com/doc/mysql/en/Subqueries.html
>
> To see how to rewrite some subquery SQL as joins,
> go
> to
>
>
http://dev.mysql.com/doc/mysql/en/Rewriting_subqueries.html
>
> SELECT newsletter_series.Series_ID,
> newsletter_series.Series_Title
> FROM newsletter_series
> LEFT JOIN newsletter_subscriptions
> ON newsletter_series.Series_ID =
> newsletter_subscription.Series_ID
> AND newsletter_subscriptions.Subscriber_ID =
> '#CurrentSubscriber.Subscriber_ID#'
> WHERE newsletter_subscriptions.Subscriber_ID IS
> NULL
>
=====
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
