本文介绍了JPQL JOINS与嵌套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
发布评论