Hi, i have problem..I want to fetch data from two tables which are inter related through primary key
Scenario is: I have table Applicant in which there are attribute "name" & "ration_Id" and other table is Certificate which include attribute "status".Now i want to fetch data from both tables on the basis of "EnrolmentId" which is primary key of Applicant table and foreign key for Certificate and (then validation will be applied on obtained list ) how to store that list i.e*.list type* In Sql..it can be like this "Select a.name,a.ration_Id,c.status from Applicant a,Certificate c where a.enrolmentI=c.enrolmentId" But i want to know how to write it in Cayenne. -- View this message in context: http://cayenne.195.n3.nabble.com/Fetching-data-from-two-related-tables-simultaneoulsy-tp3943892p3943892.html Sent from the Cayenne - User mailing list archive at Nabble.com.
