I'm trying to do multiple queries in one like this (using UNION):
Code: Select all
(SELECT time_total
FROM los_results
WHERE competition_id = '3'
ORDER BY time_total ASC)
UNION
(SELECT time_total
FROM los_results
WHERE competition_id = '7'
ORDER BY time_total ASC)
UNION
...
(and no, I don't want to sort the whole result, just the single queries)
Is there some limitation with using UNION that I don't know about?
Thanks in advance