I did try the SELECT ... WHERE MyField IN (SELECT ... INNER JOIN ...) trick, but it still using a temporary index. I guess I will try to benchmark the single-SELECT statement against 2 separate one to see which is faster.

>Did you read the whole thread? You may also play with derived tables, but I think with multiple joins you may never be able to achieve the best optimization.