Union the subquery
mysql> mysql> mysql> SELECT * -> FROM (SELECT 'Stratford' AS TOWN, 4 AS NUMBER -> UNION -> SELECT 'Plymouth', 6 -> UNION -> SELECT 'Inglewood', 1 -> UNION -> SELECT 'Douglas', 2) AS TOWNS -> ORDER BY TOWN; +-----------+--------+ | TOWN | NUMBER | +-----------+--------+ | Douglas | 2 | | Inglewood | 1 | | Plymouth | 6 | | Stratford | 4 | +-----------+--------+ 4 rows in set (0.00 sec) mysql> mysql>