Hi,


select acno from rcb_acct
where acno in ('555555666666666','333333333333333')
and lgon_pref = 'MYN'
-- removed order by clause from here; now it will work
union
select acno from rcb_acct
where lgon_pref = 'MYN'
order by acno


Pls. check.


P. Soni