Inner joins vs IN/EXISTS - SQL in 60 seconds
An inner join returns rows and columns from both tables. Semijoins (IN/EXISTS) only return data from one table. Watch this short to see the difference
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