cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joe Baldwin <jfbald...@earthlink.net>
Subject Re: Queries with multiple tables and results
Date Tue, 22 May 2012 12:12:39 GMT
If what you are referring to is an "INNER JOIN" then you might look into the documentation
here

	http://cayenne.apache.org/doc30/qualifier-expressions.html

You would need to create a Qualifier Expression object using the Cayenne JOIN Semantics, to
give to the Query object.

Someone else might be able to give an example of a suitable Cayenne Expression.

Joe

On May 22, 2012, at 6:54 AM, pk_cayenne wrote:

> Hello,
> I am a newbie with in cayenne and in english too.
> I am using cayenne 3.0.2
> Here is my probleme
> I have two tables let say *table1 (id1, name, surname)* and *table2(id2,
> title, amount)* with oracle database
> And  my query is like this  
> select name, title, amount  from table1, table2 where id1=id2
> 
> Now my  question : Would you show me , how  can I end up with it (concrete
> example please)? (I mean my result must be   objetcs []). I did not see
> anything in the cayenne doc that meet  my needs.
> 
> Thank you very much for your help
> 
> --
> View this message in context: http://cayenne.195.n3.nabble.com/Queries-with-multiple-tables-and-results-tp4006413.html
> Sent from the Cayenne - User mailing list archive at Nabble.com.


Mime
View raw message