lt into it. You have to specifically
> ask for that sorting to NOT happen if you don't want it). Now that you no
> longer need it, you can also drop the temp table:
>
> DROP TEMPORARY TABLE tmpStats;
>
> HTH,
> Shawn Green
> Database Administrator
> Unimin Corp
For me, a Newbie, this is a tricky one. I've been through the manual and this
archive, but haven't found a solution. Could someone of you experienced please
help?
Is it possible to make this query in one single SQL-statement? (Using MySQL
4.0.15 - If this can be done smarter in 4.1.x, please she