The only way I can explain it is with an example:
Basically table one has ALL records and table 2 is a subset of table one but all with sanantonio. I want to know who in table 2 has only the one record in table 1. The result set would be
since they have only the one record in table 1. I've attached my script and it returns 0 records and I know there should be some.
SELECT [email business]
WHERE [email business] NOT IN
(SELECT [email business]
WHERE eventname <> 'SanAntonio')