Clause ORDER BY

[Miguel61]

Hi there, I need your appreciated help.

The table `_tbl_C`:

ID	MCR_Cod		MCR_Den
1	DCE 		DCE - MAC
2	DNE  		DNE - MNE
3	DNO		DNO - MNO
4	DSU		DSU - MSU

The SQL Query:

SELECT C.MCR_Cod 
     , C.MCR_Den 
   FROM _tbl_r R INNER JOIN _tbl_C ON 
      R.CFT_Cod = C.CFT_Cod 
   WHERE 1 
GROUP BY C.MCR_Cod 
       , C.MCR_Den;

In the output I have this order (no clause in the sql query):

MCR_Cod
DCE
DNE
DNO
DSU

I need this other output:

MCR_Cod
DNO
DNE
DCE
DSU

Can you help me?
Thanks in advance.

[r937]

your query doesn't match your table (there is no CFT_Cod column), but i guess that's not important to your question

the GROUP BY seems redundant, but maybe that's because you have redundant data, so i guess that's not important to your question

ORDER 
    BY CASE WHEN MCR_Cod = 'DSU' 
            THEN 'humpty' 
            ELSE 'dumpty' END
     , MCR_Cod DESC

[Miguel61]

I can't thank you enough for the help. That worked perfectly.