Mark,
> SELECT
> "A"."SUBSCRIBER_NAME" , "A"."ACCOUNT_NUMBER"
> FROM "A"
> WHERE
> "A"."ACCOUNT_NUMBER"
> NOT IN
> (
> SELECT
> "B"."ACCOUNT_NUMBER"
> FROM "B"
> )
Use "WHERE NOT EXISTS" instead. See the documentation on SELECT for how to
write this clause.
--
Josh Berkus
Aglio Database Solutions
San Francisco