Hi,
I have to display some records in order for a specific category.
SELECT G.ACCESS_ID accId ,ACCESS_RES accRes, substr(G.ACCESS_NAME,5) name , G.ACCESS_DESC_ID descid FROM MEMS_ACCESS G,
MEMS_ROLE B, MEMS_ACCESS_DESC C WHERE B.ROLENAME='SysUser' AND G.ACCESS_ID= B.ACCESS_ID
AND G.ACCESS_DESC_ID=C.ACCESS_DESC_ID
I have to display the records such that I get the records order by "name" only for the ACCESS_DESC_ID = 3 and the rest records should get displayed in their normal order as in database.
I tried using UNION and order by for required condition only but still I am not getting the required order.
select GDF.accId,GDF.accRes,GDF.name ,GDF.descid from
(SELECT G.ACCESS_ID accId ,ACCESS_RES accRes, substr(G.ACCESS_NAME,5) name , G.ACCESS_DESC_ID descid FROM MEMS_ACCESS G,
MEMS_ROLE B, MEMS_ACCESS_DESC C WHERE B.ROLENAME='SysUser' AND G.ACCESS_ID= B.ACCESS_ID
AND G.ACCESS_DESC_ID=C.ACCESS_DESC_ID and G.ACCESS_DESC_ID = 3
ORDER BY substr(G.ACCESS_NAME,5)) GDF
union
SELECT A.ACCESS_ID,ACCESS_RES, substr(A.ACCESS_NAME,5), A.ACCESS_DESC_ID descid FROM MEMS_ACCESS A,
MEMS_ROLE B, MEMS_ACCESS_DESC C WHERE B.ROLENAME='SysUser' AND A.ACCESS_ID= B.ACCESS_ID
AND A.ACCESS_DESC_ID=C.ACCESS_DESC_ID and A.ACCESS_DESC_ID <> 3
Please suggest a way to do so.
Regards,
Mahi