Question:
How do I compare two tables and extract only where field1 doesn’t match field2? Will MINUS do it?
Answer:
Yes, but it’s not that direct. To do MINUS (or DIFFERENCE), I think you need to use WHERE NOT IN like this:
SELECT t1.c1 from t1 where t1.c1 NOT IN (select t2.c1 from t2)