I cannot help you on specific performance timings --
but if the result is the same, the database engine can use whatever
trick to retrieve them. That being said, a "subquery/derived table"
could then be rewritten (internally) to a JOIN, for example.
Martijn Tonies
Database Workbench - development
I'm not (yet) using sub-queries since the old version of MySQL were
unable to handle them, then I was using 'join'.
I wish to know if it's possibile to do all what I did with 'join'
with subqueries.
and which one is faster/better to use?
for example it'd be possibile to 'translate' that us
