A lot of developers get the distinction between JOIN and SEMI-JOIN wrong. Let me explain... What are JOIN and SEMI-JOIN A little bit of relational algebra first. What is an (INNER) JOIN? An JOIN is nothing but a filtered cartesian product. And what is a cartesian product? Wikipedia explains this very nicely: for sets A … Continue reading SQL JOIN or EXISTS? Chances Are, You’re Doing it Wrong
Tag: in
The truth about IN and EXISTS in SQL
Very nice article, finally getting rid of some doubts... (at least for Oracle) http://explainextended.com/2009/09/30/in-vs-join-vs-exists-oracle/