Expression: NOT EXISTS... JOIN...

From: Zvonimir Spajic (z.spaji..scensys.de)
Date: Fri Jul 01 2005 - 06:39:24 EDT

  • Next message: Todd O'Bryan: "Re: Keeping sync modeler files with db"

    Hello,

    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.

    Thank you for helping
    Zvonimir

    This archive was generated by hypermail 2.0.0 : Fri Jul 01 2005 - 06:39:28 EDT