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)
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
