Re: Using the IN function

2001-04-26 Thread Robert Schelander
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

RE: Using the IN function

2001-04-26 Thread Bruce Stewart
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

Using the IN function

2001-04-26 Thread Bobby Chopra
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