There is a syntactical error in the following statement...it will never return any rows because it is selecting from Table2 in the query AND the "NOT in" sub-query.

Select a

From Table2

Where...