Eric, This example is old (Cayenne 1.2):
http://cwiki.apache.org/CAY/cayenne-in-motion.html But it pretty much applies to Cayenne 2.0 and 3.0, too. Look at that page and do a search/find for "expression". There are many examples of creating query expressions using joins in that example. Let us know if you continue to have questions. Thanks, /dev/mrg On Feb 13, 2008 2:04 PM, Eric Polino <[EMAIL PROTECTED]> wrote: > I've been using the modeler and the relationships are setup, I just > don't know how to do queries based on those relationship...ie the one > mentioned above