If you map id as relationship key, you should consilder using simple
equalition rather than IN, e.g.:
ExpressionFactory.matchExp("toMyothertable.something", true)
otherwise, I think you can do this using EJBQLQuery [1]:
select mt FROM mytable mt WHERE mt.id in (select mot.id FROM myothertable
WHER
Hello,
Could you please guide me how to code a query like the following in
cayenne:
SELECT *
FROM mytable
WHERE id IN (SELECT ids FROM myothertable WHERE something);
One option is SQLTemplate. How could I do it with
ExpressionFactory.inExp(...)?
Thank you,
Nikos
