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

Ben Phillips ben at inchima.com
Fri Feb 15 07:22:01 CST 2002

> anyhow...
> nice design
> congrats for not doing this in the application logic

why thankyou! :o)

> as for your problem, you were so close --
>      select * from USER
>          left join   NEWSLETTER_SENT
>               on USER.userid = NEWSLETTER_SENT.userid
>                           and NEWSLETTER_SENT.newsletterid='$n'
>          where NEWSLETTER_SENT.userid is NULL

brilliant, thanks! i tried it with: NEWSLETTER_SENT.newsletterid='$n' in the
where clause!! no wonder i couldn't get my head round it.

thanks for freeing me up to do some actual work today! :o)


More information about the thelist mailing list