[thelist] using SQL left join query and NULL to find records NOT in a table

[Shashank Tripathi]

Ben, you could try including the newsletterid condition in your Join
clause. I haven't tried it, but it could be somewhat like this..


    select
          a.userid
          ,a.firstname
          ,a.email
          ,a.sendnewsletter
          ,b.newsletterid
    from
          USER a
    left join
          NEWSLETTER_SENT b
    on
          a.userid = b.userid
      and b.newsletterid = $n
    where
          b.userid is null


Hope this is useful.

Shashank