This is why.
Note to self: Only use subqueries ( SELECT * FROM `table1` WHERE `id` IN (SELECT `id` FROM `table2`) ) when it is impossible to achieve the same result using joins.
[tags]mysql, database, optimisation, queries, subqueries[/tags]
Never allow your career to be stagnant; whether you want a promotion, better compensation or a more fullfilling job, you’ve got the power to make it happen!