mysql - HQL : inner join

Question

我想在 hql 查询中进行内部联接，但出现此错误:

Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: ( ...

SELECT new myDto(
                col1, col2
            FROM table1,table2
            INNER JOIN (
                SELECT foo, bar, ...  max(nb) as numberBar
                FROM table1
                GROUP BY foo, bar ...
             )  myAlias

             ON table1.foo = myAlias.foo
             AND table1.bar = myAlias.bar
             ...

查询在 sqldeveloper 中有效

Answer 1

只需检查您发布的查询，我认为您必须在 col2 之后关闭 new myDto 的括号，因为在您发布的查询中未关闭:

SELECT new myDto(
                col1, col2)
            FROM table1,table2
            INNER JOIN (
                SELECT foo, bar, ...  max(nb) as numberBar
                FROM table1
                GROUP BY foo, bar ...
             )  myAlias

             ON table1.foo = myAlias.foo
             AND table1.bar = myAlias.bar
             ...