>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!
I'm a little confused by the question. One way or another he would have to have access to the backend to get the data in Oracle. What you would do is create a remote view of the Oracle table (DBC required), then issue your query on the local table and the remote view.
Mark McCasland
Midlothian, TX USA