The correct answer is : All Customers who have at least one Order.
Because the query is translated into "For Sun Java Application Server and MySQL, select c from Customer c, IN(c.orders) o actually gets translated to : SELECT DISTINCT t0.ID, t0.LASTNAME FROM CUSTOMER t0, ORDER t1 WHERE (t1.CUSTOMER_ID = t0.ID) "
But in EJB in action, the book says one can perform theta join using ',' in the "from" clause.
I am totally confused.
Houston Rockets go go go!
posted 7 years ago
I think the book does not say that...
See this example
SELECT i FROM Item i, Category c WHERE i.star = c.rating
the relationship has been made using where not by ','
Anyway enthus answer is correct according to experience and spec.