Title: EJBQL and SQL

Hello All,
        If my ejbquery is
                Select Object(c) from Customer c, Address a ;
        Which of the following sql queries is correct?
                a)   Select c.name from Customer c, Address a;
                b)   Select c.name from Customer c, Address a where c.fk_addressID= a.addressID;

        In mastering EJB 2 (pg 573) , it is said that first one is correct.But I feel that second one is correct because duplicates are removed.

        Please help me.

TIA
Karthik.
       


      
       

--------------------------------------------------------------------------------------------------------------------
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they are addressed. If you have received this email in error please notify the
originator of the message.

Any views expressed in this message are those of the individual
sender, except where the sender specifies and with authority,
states them to be the views of Huawei Technologies India Pvt. Ltd.

Reply via email to