将SQL Join转换为HQL Join:多个Join，一张表，非主键Join

Question

我已经搜索过了，但还没有找到一个很好的范例。我有以下SQL语句，它工作得很好：

select CatA.* 
FROM TestContentElementCETPropertyValue as CatA 
  JOIN TestContentElementCETPropertyValue as CatB 
    ON CatA.testcontentelementid = CatB.testcontentelementid 
  JOIN TestContentElementCETPropertyValue as CatC
    ON CatB.testcontentelementid = CatC.testcontentelementid 
WHERE  CatA.contentelementtypepropertyid = 141 
  AND CatB.contentelementtypepropertyid = 4903   
  AND CatC.contentelementtypepropertyid = 4990

更新:需要说明的是，ON字段和WHERE字段都不是主键。

作为HQL的新手，我正在努力弄清楚，一旦"ON“子句消失了，该如何写这篇文章。

Answer 1

我想通了。连接是隐式的。

String queryString="        select CatA FROM "   +
    "TestContentElementCETPropertyValue as CatA, "+
    "TestContentElementCETPropertyValue as CatB, "+
    "TestContentElementCETPropertyValue as CatC "+
    "WHERE  CatA.contentElementTypeProperty.id = 141 "+
    "AND CatB.contentElementTypeProperty.id= 4903   "+
    "AND CatC.contentElementTypeProperty.id = 4990  "+
    "AND CatA.testContentElement.id = CatB.testContentElement.id "+
    "AND CatB.testContentElement.id = CatC.testContentElement.id ";