miguel61 — 2011-08-01T05:36:10-04:00 — #1
Hi there, I need your appreciated help.
ID MCR_Cod MCR_Den
1 DCE DCE - MAC
2 DNE DNE - MNE
3 DNO DNO - MNO
4 DSU DSU - MSU
The SQL Query:
FROM _tbl_r R INNER JOIN _tbl_C ON
R.CFT_Cod = C.CFT_Cod
GROUP BY C.MCR_Cod
In the output I have this order (no clause in the sql query):
I need this other output:
Can you help me?
Thanks in advance.
r937 — 2011-08-01T07:29:22-04:00 — #2
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
BY CASE WHEN MCR_Cod = 'DSU'
ELSE 'dumpty' END
, MCR_Cod DESC
miguel61 — 2011-08-01T08:31:23-04:00 — #3
I can't thank you enough for the help. That worked perfectly.