Re: double inner join

• Previous message: Dave Merrin: "double inner join"
• In reply to: Dave Merrin: "double inner join"
• Next in thread: Cris Daniluk: "Re: double inner join"
• Reply: Cris Daniluk: "Re: double inner join"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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
>
>

• Next message: Cris Daniluk: "Re: double inner join"
• Previous message: Dave Merrin: "double inner join"
• In reply to: Dave Merrin: "double inner join"
• Next in thread: Cris Daniluk: "Re: double inner join"
• Reply: Cris Daniluk: "Re: double inner join"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Thu Oct 06 2005 - 14:36:50 EDT