Mock Exam Q.12.page 428 HFEJB

[Girija Siva]

Hi All
THe question 12 on page 428 says answer D is correct. Does not this answer return all the order even the ones that have no line items.
Thanks

Here is the reference of the question
Given CMP beans
CustomerBean (1) <-----> OrderBean(n)
OrderBean (1) <------> LineItemBean(n)

Which will return all the orders that have line items?

A. SELECT DISTINCT o
FROM Order o, IN (o.lineItems)li
B SELECT DISTINCT (OBJECT)o
FROM Order o, IN (o.lineItems)li
C SELECT OBJECT(o)
FROM Order o
WHERE o.lineItems = 0
D SELECT OBJECT(o0
FROM Order o

[Simon Ingram]

I agree with you, Girija. The book seems wrong.

[Roger Chung-Wee]

This issue has been answered here.

[Girija Siva]

Thanks Simon and Roger