Subject SQL Select Joins Syntax
Author Kevin Stanton
Greetings,
I am currently joining:

select [field list]
from Table1 T1
left outer join Table2 T2 on T1.ID = T2.ID

This gives me everything in Table1 whether or not it exists in Table2.

What is the best way to find out what is in Table2 that is not in Table1.

Thanks,
Kevin