Hi,

A friend of mine has a local table of social security numbers. He would like to retrieve a number of fields from an Oracle database for each of those social security numbers. If he was just dealing with local tables, his query wok something like:
SELECT x, y, z FROM EmployeeDetails
WHERE SSN IN (SELECT SSN FROM MySSNList)

If he had access to the backend Oracle environment, he could create a temporary table there and stuff it with the SSN values from his local table.

But since he does not have access to the backend, is it possible to do such a join thru SQL Passthru?

Thanks!