livewire1974 — 2011-06-07T11:49:57-04:00 — #1
I am running a mail program, and it crashed in mid session. So I need to restart it but only using email addresses that the email was not sent to.
I have one table of email addresses, which has the fields
and another, called logs
id, email, date
How do I select all the emails in the first table that are not in the second?
Thanks in advance.
jurn — 2011-06-07T12:36:26-04:00 — #2
select email from addresses where
email not in (select email from logs);
r937 — 2011-06-07T13:00:44-04:00 — #3
ON logs.email = addresses.email
WHERE logs.email IS NULL
livewire1974 — 2011-06-07T13:12:58-04:00 — #4
Cool guys, thanks