Re: "IN" keyword supported?

2001-12-09 Thread Tony Buckley
Hi Bennett, - Original Message - From: "Bennett Haselton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, December 09, 2001 12:31 PM Subject: "IN" keyword supported? > I'm trying to use the "IN" operator as described in my databases textbook > from college. This query: > > se

RE: "IN" keyword supported?

2001-12-09 Thread Carsten H. Pedersen
> I'm trying to use the "IN" operator as described in my databases textbook > from college. This query: > > select count(*) from user where user.ID in (select ID from user); > > is supposed to evaluate to "count the number of rows in the 'user' table > where the ID field is in the set of all ID f