Select from field exists function

[Anonymous]

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

[maneshkhottcpl]

Hi,

Use the following.

// Gives u the owners

A:

Load distinct owners as Owners_T from table;

B:

Load * from Table where not exists (Owners_T, users);

drop table A;

will work.

or send me ur application with sample data.