JPQL JOINS与嵌套SELECT [英] JPQL JOINS with nested SELECT

问题描述

我可以在JPQL上执行类似的操作吗?

Can I do something like this on JPQL?

SELECT NEW com.MyDTO(p.a, p.b, q.c, q.d)
FROM
(SELECT r.* FROM MyDTO1 r ) p
LEFT OUTER JOIN
(SELECT s.* FROM MyDTO2 s ) q
ON p.x = q.y 

还是类似的? (以上查询已与本机和JPQL混合在一起，因此请不要误解)

or similar? (Above query has mixed with native and JPQL, so don't misunderstand)

我认为这部分有问题.

FROM
(SELECT r.* FROM MyDTO1 r ) p

当我尝试执行时，出现此错误.

When I'm trying to execute I'm getting this error.

Exception Description: Syntax error parsing the query [.....], unexpected token [(]

谢谢！

推荐答案

不，您不能.引用文档:

请注意，HQL子查询只能在select或 条款.

Note that HQL subqueries can occur only in the select or where clauses.

这篇关于JPQL JOINS与嵌套SELECT的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！