subselect query

From: moraru_et..pymac.com
Date: Tue Jan 18 2005 - 11:00:06 EST

  • Next message: Joshua Pyle: "Re: subselect query"

    ('binary' encoding is not supported, stored as-is) 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:00:09 EST