I have a table with user id's and another with user id's linked to a group.
users table |user_id| username | | 1 | Lloyd Thomas| | 2 | John Smith | Group table |group id| user_id| | 1 | 1 | I am trying to create a query which selects a user where it is not part of a specified group. But it does not seem to work as I get multiple results for the same user id's. sql--------------------------------------------------- Select U.user_id from users as U, grp_user as G where U.user_id != G.user_id ------------------------------------------------------------ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
