RE: [sqlite] user id select

[Williams, Kenneth (Ken) (TLR Corp)]

> -----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]