Benjamin Eberlei
added a comment - 04/May/13 12:45 PM The query is correct, "c.parentCategory c2" generates the right query as per your screenshot. Its just not the order of the queries that you want, Native SQL wil help you here.