Re: subselect query

From: Joshua Pyle (joshua.t.pyl..mail.com)
Date: Tue Jan 18 2005 - 11:02:57 EST

  • Next message: Andrus Adamchik: "Re: subselect query"

    You could always use the SQLTemplate Class...

    SQLTemplate selectQuery = new SQLTemplate(Artist.class, "select * from
    ARTIST", true);

    http://objectstyle.org/cayenne/userguide/fetch/sqltemplate.html 

    -- 
Joshua T. Pyle
Go has always existed.

    On Tue, 18 Jan 2005 09:00:06 -0700, moraru_et..pymac.com
<moraru_et..pymac.com> wrote:
> please tell me how to model in cayenne this kind of query:
> 
> select * from employee where employee.id not in (select id_emp from depemp where
> id_dept='100').
> 
> i want to select the users who are outside the departmnet with id=100
> 
> the tables are department, employee and the n:m relation is mapped with the table
> depemp.
> 
>

    This archive was generated by hypermail 2.0.0 : Tue Jan 18 2005 - 11:02:59 EST