union all order by

shashi_s · #1 (**permalink**) 04-12-07, 03:27

HI,

got this sql query..which is a follow up from my prev thread....
select * from A where A.id < 1000 union all select * from A where A.id > 5000
order by A.id

this gives me an error

of an invalid order by

i need to use the "union" is there a way to order the result?

shashi_s · #2 (**permalink**) 04-12-07, 03:31

Please diregard...i was being dumb, a bit of further googling helped me out
i feel the pain

aschk · #3 (**permalink**) 04-12-07, 08:42

LOL, i hope you used an OR statement in your where clause instead?
Just for clarity I will rewrite your query :

Code:

SELECT *
FROM <table> A
WHERE (A.id < 1000) 
OR (A.id > 5000)
ORDER BY A.id

Incidently; why do you "need" to use the union clause?

Internet Services

Web Development

Digital Marketing

Consumer Tech