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
> 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
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 field value
