UNION ALL -> Problem beim Sortieren

[Union]

In einer Union darf es nur ein ORDER BY statement geben. Das Gewünschte kannst Du so erreichen:

SQL-Code:

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