At 4:40 PM -0700 9/7/01, Anthony E. wrote:
>I've tried to do a NOT IN statement, but still am
>getting SQL syntax error.
>
>
>SELECT COUNT(*) FROM USER_TMP WHERE USER_TMP.email NOT
>IN (SELECT USER.email FROM USER);
>
>I'm trying to produce a list of records from USER_TMP
Huh? COUNT(*) produces
I've tried to do a NOT IN statement, but still am
getting SQL syntax error.
SELECT COUNT(*) FROM USER_TMP WHERE USER_TMP.email NOT
IN (SELECT USER.email FROM USER);
I'm trying to produce a list of records from USER_TMP
table where the USER_TMP.email is NOT IN USER.email.
(in other words, i wan
