About Question enthuware.oce-jpad.v6.2.481 :
Posted: Wed Jul 05, 2017 9:40 am
Hi, I used the application program, ToyAppForJPA
to try this:
"select co.id , li.quantity from CustOrder co join co.lineItems li where li.quantity =
(select max(li.quantity) from li)"
It returns the same result as:
select co.id, li.quantity from CustOrder co join co.lineItems li where li.quanity=
(Select max(line.quantity) from OrderLineItem line)
So, in this case, the last option can be correct as well.
to try this:
"select co.id , li.quantity from CustOrder co join co.lineItems li where li.quantity =
(select max(li.quantity) from li)"
It returns the same result as:
select co.id, li.quantity from CustOrder co join co.lineItems li where li.quanity=
(Select max(line.quantity) from OrderLineItem line)
So, in this case, the last option can be correct as well.