Re: Expression: NOT EXISTS... JOIN...

From: Mike Kienenberger (mkienen..laska.net)
Date: Fri Jul 01 2005 - 11:06:02 EDT

  • Next message: Kevin Menard: "Re: Subclassing a DataObject"

    Zvonimir Spajic <z.spaji..scensys.de> wrote:
    > I am trying out to build up an Expression for this SQL:
    >
    >
    > SELECT * FROM user t0
    > WHERE NOT EXISTS
    > (SELECT * FROM map_user_role t1
    > WHERE t0.username = t1.username)
    >
    >
    > What is the best way and which typ of Expression I have to use.
    > If there are more alternatives, please show me.

    I'm not sure what "NOT EXISTS" means, but it sounds like it's the same as
    "NOT IN":

    public static Expression notInExp(String pathSpec, Object value)

    This archive was generated by hypermail 2.0.0 : Fri Jul 01 2005 - 11:03:11 EDT