Thanks Ken, You make it look so simple. Lloyd ----- Original Message ----- From: "Williams, Kenneth (Ken) (TLR Corp)" <[EMAIL PROTECTED]> To: "Lloyd thomas" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, April 12, 2004 3:50 PM Subject: RE: [sqlite] user id select
> -----Original Message----- > From: Lloyd thomas [mailto:[EMAIL PROTECTED] > Sent: Sunday, April 11, 2004 1:18 PM > To: [EMAIL PROTECTED] > Subject: [sqlite] user id select > > > I am trying to create a query which selects a user where it > is not part of a > specified group. Perhaps you just want: SELECT user_id FROM users WHERE user_id NOT IN (SELECT user_id FROM grp_user WHERE group_id = 42) -Ken --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]