BaldingLoopMan (3/4/2010)

---

also u have to ensure that the aliases of everything your selecting must match between the top select and bottom select. these aliases is what you will put in your order by

-- will fail
SELECT '1a'AS a
UNION 
SELECT 2 AS b

-- will fail
SELECT 1 AS a
UNION 
SELECT 2 AS b
ORDER BY B

-- will run
SELECT 1 AS a
UNION 
SELECT 2 AS b

u have to ensure that the aliases of everything your selecting must match between the top select and bottom select