UNION ALL -> Problem beim Sortieren

[Codewalker]

Versuch doch mal folgendes:

SQL-Code:

Select * FROM
(
SELECT 1 as DescriptionNumber, Description1 as Description 
FROM Description 
WHERE 
... 

UNION ALL 

SELECT 2 as DescriptionNumber, Description2 as Description 
FROM Description 
WHERE 
... 
)
ORDER BY Description ASC