NOT IN & NOT EXISTS Antijoins - SQL in 60 seconds
Use NOT IN & NOT EXISTS to find all the rows from a table with no matching values in a subquery. Aka Antijoins.
Need help with SQL?
Learn SQL in this free course https://devgym.oracle.com/pls/apex/dg...
Ask us over on AskTOM: https://asktom.oracle.com
Twitter: / chrisrsaxon
Daily SQL Twitter tips: / sqldaily
All Things SQL blog: https://blogs.oracle.com/sql/
Test your SQL Skills on the Oracle Dev Gym: https://devgym.oracle.com/
===========================
The Magic of SQL with Chris Saxon