posted 17 years ago
Hi,
I need help in formulating a JPQL query in this situation:
1. I have Customer and Order entities and I want all the Customers who have ordered something. I am thinking:
select c from Customer c, In(c.orders) o
Is that correct? Would the query be different in EJBQL and JPQL for this situation?
2. What if I want all the customers who have an order that is larger than say 100$?
select c from Customer c, In(c.orders) o where o.amt>100
Any ideas?
Also, can someone point me to some resource that contains differences between EJBQL and JPQL?? I am really confused with both.