select object(p) from Orders o, IN(o.products) p where o.storename="ABC" Now, Is my answer correct... ???
In my opinion, your answer is correct since the identification variables o and p are defined correct and the comparison is made with a single_valued_path_expression. The only thing that is wrong, as far as I know, is that you use double-quotes for the string literal.
However, an easier way of thinking about this problem is the following:
you'r relationsip is Orders(1)------(m)Products
that's the same as Products(m)------(1)Orders
Further, both "Products" and "Orders" must be abstract scheme names, since you must decribe their relationsip (or does anybody disagree?).
Therefore you could write:
select object(p) from products p where p.orders.storename='ABC'
this example corresponds to the second example in 11.3.1 of the spec (see also the relationsip diagram on page 221 that corresponds to all examples)
do you agree ?
What's this answer that they have provided with "Member of .