Hi Pinaki,
I have one question, My query has below joins
FROM Certificate c, Borrower lb, OPUS_Code oc, Loan l, Branch b, Customer
cu
WHERE c.Cert_ID = lb.cert_ID
AND c.Cert_ID = l.Cert_ID
AND l.Loan_Orig_Branch_ID = b.Branch_ID
AND b.Branch_Cust_ID = cu.Cust_ID
AND lb.loan_Brwr_Seq_ID = 1
AND c.Cert_Current_Status_Code = oc.OPUS_Code_ID
AND lb.ssnNumber = :ssnNumber"
Here Certificate and Borrower,loan,opus_code table has relationship. however
Branch, Customer table doesn't have relationship with Certificate table. So
how can i put diffrent tables in dynamic query?
Thanks
Chintan
--
View this message in context:
http://openjpa.208410.n2.nabble.com/Example-of-join-in-Criteria-API-tp6291890p6307039.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
