1 Reply Latest reply: Jan 25, 2011 6:17 AM by Manesh KHOT RSS

    Select from field exists function

      Thanks in advance for your replies.

      I have a data table which loads a few fields including 2 fields - owner and user.

      The file belongs to the owner but any user can work on it, owners can also be users.

      I need to flag users who do not exist in owners field

      What I need but cannot figure out is something like

      SELECT from user WHERE they do not exist in owner on any row at all, ever (so exclude owners from users list)

      I tried with exists function but no joy

      Hope this makes sense

      Thanks again