Jeff Moden (10/17/2013)

---

ScottPletcher (10/17/2013)

---

Or just:

ORDER BY 1

I often avoid using the column names at all in UNIONed queries, as the names somehow seem to

change a lot 🙂 :

Thank goodness that method has finally been deprecated.