Question: difference between inner join and where exists?
Answer: Generally speaking, INNER JOIN and EXISTS are different things. ... If you do an inner join on a UNIQUE column, they exhibit same performance. If you do an inner join on a recordset with DISTINCT applied (to get rid of the duplicates), EXISTS is usually faster.