Is there a way to have something in your select clause, so that you can use it for order by clause , but not have it display? For example:
select acno,1 ordering from rcb_acct
where acno in ('555555666666666','333333333333333')
and lgon_pref = 'MYN'
select acno,2 ordering from rcb_acct
where lgon_pref = 'MYN'
order by ordering, acno
I don't want the ordering field returned. I just want it to put my results in the correct order.