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]
