[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