var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: union all order by
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?
Please diregard...i was being dumb, a bit of further googling helped me out
i feel the pain
LOL, i hope you used an OR statement in your where clause instead?
Just for clarity I will rewrite your query :
Incidently; why do you "need" to use the union clause?
FROM <table> A
WHERE (A.id < 1000)
OR (A.id > 5000)
ORDER BY A.id