I have searched example for SQL joins using apache cayenne but I found nothing. How can i use selectQuery with Expression for JOINs or I have to use SQLTemplete or EJBQL Query.
Like I have a query - " Select p.name, a.address from Person p RIGHT OUTER JOIN Address a ON p.personId = a.personId where p.name LIKE 'Deep%' AND p.age > 18 " then to write it in cayenne ? -- Thanks and Regards Deepesh Jain