If i understand rishi's query properly, Is'nt he questioning this? -->
Originally posted by Prashant Satarkar:
In other words: The identifier OBJECT in the SELECT clause is required, because the OBJECT operator must qualify all stand-alone identification variables in the SELECT clause.
Either way guess OBJECT is not required for
SELECT p.company FROM Person AS p
where company is a CMR with Company entity bean.
So Rishi if I understand your question correctly, are you saying that when OBJECT is not used here to identify the Company bean why is it needed to indentify the Person bean in the query you posted?