nested select sometimes better than big join?

[atDev]

Hi,

We have a situation where we must join 3 tables. 1 table is a N to N relationship table that when we do this join it is impossible to use both columns of the N to N relationship table in the index because both columns are keys for the other 2 tables out of the three.

So with this in mind is it possible that doing 2 selects (one nested in the other) to get the data we need may be faster?

[Mandes]

I doubt it, but you should really ask this in the MySQL forum.

[atDev]

Whoops, sorry wrong forum.