For instance: Code: SELECT tdate,description FROM transactions_2011_12 AS t LEFT JOIN products AS p ON ... I believe MySQL is creating a temporary table with the entire contents of the subquery ...