Re: double inner join

From: Cris Daniluk (cris.danilu..mail.com)
Date: Thu Oct 06 2005 - 14:53:24 EDT

  • Next message: Joshua Pyle: "Re: Query qualifier in modeler"

    I thought I saw a post a while back about someone doing this by
    creating another ObjEntity ref to the table or something like that?

    I could be smoking crack...

    Cris

    On 10/6/05, Andrus Adamchik <andru..bjectstyle.org> wrote:
    > There was a proposal to add that, but it has never materialized into
    > code (maybe someday)
    >
    > http://www.objectstyle.org/cayenne/lists/cayenne-devel/2003/09/0096.html
    >
    > So I guess for now SQLTemplate is the only way.
    >
    > Andrus
    >
    >
    > On Oct 6, 2005, at 12:47 PM, Dave Merrin wrote:
    >
    > > i'd like to accomplish something like this using Expresssions:
    > >
    > > from Cat cat
    > > inner join cat.kittens as kittens0
    > > inner join cat.kittens as kittens1
    > > where kittens0.name = 'Fred'
    > > and kittens1.name = 'Amy'
    > >
    > > which would find cats that have at least two kittens, one named
    > > fred and
    > > another amy.
    > >
    > > How do I do this using Expressions?
    > >
    > > Cheers,
    > >
    > > Dave
    > >
    > >
    >
    >



    This archive was generated by hypermail 2.0.0 : Thu Oct 06 2005 - 14:53:26 EDT