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.
