Re: [sqlite] user id select

2004-04-12 Thread Lloyd thomas
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 P

RE: [sqlite] user id select

2004-04-12 Thread 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 >

Re: [sqlite] user id select

2004-04-11 Thread Lloyd thomas
x27;1'or G.group_id is null; - Original Message - From: "Christian Smith" <[EMAIL PROTECTED]> To: "Lloyd thomas" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, April 11, 2004 9:3

Re: [sqlite] user id select

2004-04-11 Thread Christian Smith
On Sun, 11 Apr 2004, Lloyd thomas wrote: >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 tr

[sqlite] user id select

2004-04-11 Thread Lloyd thomas
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 i