double inner join

From: Dave Merrin (dmerri..pasystems.co.uk)
Date: Thu Oct 06 2005 - 12:47:36 EDT

  • Next message: Andrus Adamchik: "Re: double inner join"

    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 - 12:48:10 EDT