Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

SQL query help



I have a list of 100 SSNs, say. There is a table that stores SSNs. this
table has 60 of the 100 SSNs.
Is it possible to write a query that gives me the 40 SSNs that are not
there - without using temp tables/inserts in to any table and without
writing PL/SQL(meaning without writing to files/using looping constructs
etc.).
I want to avoid getting the 60 SSNs that are there in the table, bumping it
up against the 100 using other tools..

It all boils down to : how to convert a comma-seperated list to a record
set/query output using just a query ?

Any pointers will be greatly appreciated...

Thanks.





<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.