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

rudy r937 at interlog.com
Fri Feb 15 07:09:00 CST 2002


>of course, it's MySQL and i don't have temporary tables or sub-selects...

hi benji

i thought they were going to introduce subselects in release 4?

anyhow...

nice design

congrats for not doing this in the application logic

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


rudy




More information about the thelist mailing list