I wonder how I can realise the query of selecting all users, who have no roles in any groups?!
Would the following SQL handle this?
Select * From TURBINE_USER where USER_ID not in (select distinct USER_ID from TURBINE_USER_GROUP_ROLE)
Do the distinct query first and then pass the results as the NOT IN argument.
Eric
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
