sql - jpql select into select -
it possible use 1 select's results table another(in other word: upper) select statement. there equivalent in jpql
here sample sql statements
select x.name, sls.total benefit (select * person) x inner join salesman sls on sls.person_id = x.id
what equivalant statement in jpql?
no, not possible. subqueries can used in , having clauses, told in jpa 2.0 specification:
subqueries may used in or having clause.[58]
...
[58] subqueries restricted , having clauses in release. support subqueries in clause considered in later release of specification.
also in jpa 2.1 has not been changed.
Comments
Post a Comment