I have two table with same structure (T1 and T2).
T2 is a subset of T1.
How can I select from T1 such that I can exclude the rows found in T2.
e.g. T1 has 467 rows, T2 has 72 rows. I want to get the 395 rows
is there something like a
SELECT * FROM T1 NOT IN T2
Thanks in advance