Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: neutral (athena.apache.org: 216.139.236.26 is neither permitted
 nor denied by domain of coolyunus1986@gmail.com)
Date: Fri, 27 Apr 2012 03:01:45 -0700 (PDT)
From: yunus <coolyunus1986@gmail.com>
To: user@cayenne.apache.org
Message-ID: <1335520905562-3943892.post@n3.nabble.com>
Subject: Fetching data from two related tables simultaneoulsy
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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.