How to select and sort any column from derived table by using OQL
0
I would like to select and sort some attribute of these results after execute union stament in OQL.Is there anyone know how to use OQL to achieve the same results as below SQL do? select abc.* from ( select CategoryID,CategoryName from Categories where CategoryID in (1,2) union all select CategoryID,CategoryName from Categories where CategoryID in (3,4) ) as abc order by CategoryID Thanks a lot