Merging two query results into one in Oracle

[Pawan Choure]

I have to get two different result on the same table.First Result will be get first then added by Second result

SELECT distinct cust.custid,cust.firstnm,cust.nextactiondt,cust.priorityscr,cust.lastacssts FROM Customer cust, Custqueue custqueue
WHERE cust.custid=custqueue.custid AND custqueue.qcd = 'A'
AND trunc(cust.nextactiondt)>=trunc(current_date) AND trunc(cust.lastacssts)<trunc(current_date)
ORDER BY cust.nextactiondt,cust.priorityscr desc

Custid Name Nextactiondt priorityscr lastacssts
65 A 16-JUN-11 11.52 14-MAR-11
84 B 16-JUN-11 1.38 14-MAR-11
93 C 17-JUN-11 0 18-APR-11

SELECT distinct cust.custid,cust.firstnm,cust.nextactiondt,cust.priorityscr,cust.lastacssts FROM Customer cust, Custqueue custqueue
WHERE cust.custid=custqueue.custid AND custqueue.qcd = 'A'
AND trunc(cust.nextactiondt)>=trunc(current_date) AND trunc(cust.lastacssts)=trunc(current_date)
ORDER BY cust.lastacssts,cust.nextactiondt,cust.priorityscr desc

Custid Name Nextactiondt priorityscr lastacssts
59 S 16-JUN-11 1212 16-JUN-11

I want to club the result of the two query into 1 as follows.

Custid Name Nextactiondt priorityscr lastacssts
65 A 16-JUN-11 11.52 14-MAR-11
84 B 16-JUN-11 1.38 14-MAR-11
93 C 17-JUN-11 0 18-APR-11
59 S 16-JUN-11 1212 16-JUN-11

but when i am using UNION

SELECT distinct cust.custid,cust.firstnm,cust.nextactiondt,cust.priorityscr,cust.lastacssts FROM Customer cust, Custqueue custqueue
WHERE cust.custid=custqueue.custid AND custqueue.qcd = 'A'
AND trunc(cust.nextactiondt)>=trunc(current_date) AND trunc(cust.lastacssts)<trunc(current_date)

UNION

SELECT distinct cust.custid,cust.firstnm,cust.nextactiondt,cust.priorityscr,cust.lastacssts FROM Customer cust, Custqueue custqueue
WHERE cust.custid=custqueue.custid AND custqueue.qcd = 'A'
AND trunc(cust.nextactiondt)>=trunc(current_date) AND trunc(cust.lastacssts)=trunc(current_date)
ORDER by 3,4 desc,5

I am getting

Custid Name Nextactiondt priorityscr lastacssts
59 S 16-JUN-11 1212 16-JUN-11
65 A 16-JUN-11 11.52 14-MAR-11
84 B 16-JUN-11 1.38 14-MAR-11
93 C 17-JUN-11 0 18-APR-11

but that is different from what i expect

Custid Name Nextactiondt priorityscr lastacssts
65 A 16-JUN-11 11.52 14-MAR-11
84 B 16-JUN-11 1.38 14-MAR-11
93 C 17-JUN-11 0 18-APR-11
59 S 16-JUN-11 1212 16-JUN-11

so any one know how can i append the results of two queries into one since i have order by clause in both queries and i can club them together.
Any help regarding this would be appreciated

[Fatih Keles]

I can not see your objective but this may help

select * from (select 1 lvl, x.* from my_query1 x order by <what ever you like> union select 2 lvl, y.* from my_query2 y order by <what ever you like> ) z order by z.lvl,<what ever you like>