esn studio

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.

Technorati Tags: mysql, database, optimisation, queries, subqueries

This entry was posted on Tuesday, August 7th, 2007 at 3:08 pm and is filed under PHP. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.