Question: why joins are faster than subquery?
Answer: A LEFT [OUTER] JOIN can be faster than the subquery used for the same case because the server will be able to optimize it better. ... In which Joins are used to return two or more rows whereas, Sub-queries are used to return either a row set or a scalar (single) value.