Hello everyone,
I wanted to ask a simple thing. I have a query like this:

SELECT node.name
FROM nested_category AS node,
nested_category AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND parent.name = 'ELECTRONICS'
ORDER BY node.lft;

As you can see two aliases are created for the same table, how can I do this with hibernate criteria?

thanks in advance
Mario

You may need a new relationship entry with the same table in the mapping xml to create a same alise two times

I don't like this approach, I prefer to use HQL.

With a new relationship entry with the same table in the mapping xml, the query is not built like the one I proposed.

Thank you for your response

Mario

did you try doing createAlias twice?