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.