Union question

Hi,

We have this HUGE query. It is dynamically built, so it will be different each time. The problem is, we need to order each query, not the entire UNION. So, each select needs to have it's own order by.

Can this be done in any way??

SELECT t_id, body_id, data_w, headline, teaser, name FROM zc_body zc, zc_autor za WHERE zc.a_id = za.id AND data_p < SYSDATE AND t_id = 43 AND rownum <= 1
UNION
SELECT t_id, body_id, data_w, headline, teaser, name FROM zc_body zc, zc_autor za WHERE zc.a_id = za.id AND data_p < SYSDATE AND t_id = 44 AND rownum <= 1
UNION
SELECT t_id, body_id, data_w, headline, teaser, name FROM zc_body zc, zc_autor za WHERE zc.a_id = za.id AND data_p < SYSDATE AND t_id = 45 AND rownum <= 1
UNION
SELECT t_id, body_id, data_w, headline, teaser, name FROM zc_body zc, zc_autor za WHERE zc.a_id = za.id AND data_p < SYSDATE AND t_id = 6 AND rownum <= 1
UNION
SELECT t_id, body_id, data_w, headline, teaser, name FROM zc_body zc, zc_autor za WHERE zc.a_id = za.id AND data_p < SYSDATE AND t_id = 7 AND rownum <= 1
UNION
SELECT t_id, body_id, data_w, headline, teaser, name FROM zc_body zc, zc_autor za WHERE zc.a_id = za.id AND data_p < SYSDATE AND t_id = 8 AND rownum <= 1
UNION
SELECT t_id, body_id, data_w, headline, teaser, name FROM zc_body zc, zc_autor za WHERE zc.a_id = za.id AND data_p < SYSDATE AND t_id = 21 AND rownum <= 1
UNION
SELECT t_id, body_id, data_w, headline, teaser, name FROM zc_body zc, zc_autor za WHERE zc.a_id = za.id AND data_p < SYSDATE AND t_id = 2 AND rownum <= 1
UNION
SELECT t_id, body_id, data_w, headline, teaser, name FROM zc_body zc, zc_autor za WHERE zc.a_id = za.id AND data_p < SYSDATE AND t_id = 35 AND rownum <= 1
UNION
SELECT t_id, body_id, data_w, headline, teaser, name FROM zc_body zc, zc_autor za WHERE zc.a_id = za.id AND data_p < SYSDATE AND t_id = 34 AND rownum <= 1
ORDER BY data_w DESC;

Thanks all!!! Received on Tue Jul 15 2008 - 11:52:58 CDT