[sql] order by

[piero.mac]

SELECT *
FROM dbo.TdbEntityParent E INNER JOIN
dbo.TdbGroup G ON E.GroupID = G.ID
WHERE G.ID IN ('gr_altita', 'gr_telspa', 'gr_estope')
ORDER BY FIELD(G.ID, 'gr_altita', 'gr_telspa', 'gr_estope')