cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yunus <coolyunus1...@gmail.com>
Subject Fetching data from two related tables simultaneoulsy
Date Fri, 27 Apr 2012 10:01:45 GMT
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.

Mime
View raw message