Thanks for the suggestion, but no luck. Here's the explain output for,
in order, my original query, the 2-part query, and the explicit join
(note, not quite like my first post, I had "cleaned up" my tables to
simplify the situation):
mysql> explain SELECT * FROM accounts, transactions WHERE canon_
Well, you haven't posted the output of EXPLAIN, but I'll take a guess. I
expect mysql sees your query as having a JOIN condition of
accounts.account_id = transactions.account_id and two WHERE conditions:
WHERE accounts.name = 'dave'
AND when BETWEEN '2004-02-05' AND '2004-02-10'
The optimiz
