sage -
From: "Bobby Chopra" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 26, 2001 2:09 PM
Subject: Using the IN function
> Probably a simple question:
>
> I am returning back to SQL after a break, and I was sure that I could do
the
> follow
EMAIL PROTECTED]
Subject: Using the IN function
Probably a simple question:
I am returning back to SQL after a break, and I was sure that I could do the
following when using the IN function:
SELECT field1 FROM table1 where field1 NOT IN (SELECT DISTINCT field2 FROM
table2);
but clearly not.
Could a
Probably a simple question:
I am returning back to SQL after a break, and I was sure that I could do the
following when using the IN function:
SELECT field1 FROM table1 where field1 NOT IN (SELECT DISTINCT field2 FROM
table2);
but clearly not.
Could anyone suggest what I am doing wrong, or is