| Subject | Order by in Union |
|---|---|
| Author | chherrick_2000 |
| Post date | 2005-04-18T16:10:10Z |
How do I specify an order by in a unioned query?
Example:
SELECT NAME
FROM TABLE1
UNION
SELECT NAME
FROM TABLE2
ORDER BY NAME
this doesn't appear to work.
Example:
SELECT NAME
FROM TABLE1
UNION
SELECT NAME
FROM TABLE2
ORDER BY NAME
this doesn't appear to work.