cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yunus <>
Subject Fetching data from two related tables simultaneoulsy
Date Fri, 27 Apr 2012 10:01:45 GMT
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 can be like this
"Select,a.ration_Id,c.status from Applicant a,Certificate c where

But i want to know how to write it in Cayenne.

View this message in context:
Sent from the Cayenne - User mailing list archive at

View raw message