anti-join

Finding missing emails in SQL Server

I am trying to do something I've done a million times and it's not working, can anyone tell me why? I have a table for people who sent in resumes, and it has their email address in it... I want to find out if any of these people have NOT signed up on the web site. The aspnet_Membership table has all the people who ARE signed up on the ...

Oracle Anti-Join Execution plan question

We have two tables like so: Event id type ... a bunch of other columns ProcessedEvent event_id process There are indexes defined for Event(id) (PK) ProcessedEvent (event_id, process) The first represents events in an application. The second represents the fact that a certain event got processes by a certain...