SELECT * FROM MyTable
UNION
SELECT * FROM MyTable
ORDER BY MyColumn

---

 Comments and Workarounds

---

The workaround is to use parentheses around the second query.

---

 Resolution

---

Fixed Problem on 7/18/2007 in version 1.04 build 6

---

 Products Affected

---

ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial