You should be able to create a Linked Server pointing to the Oracle database server. That ought to allow you to do what you want.
-Mike
>hello!
>
>here's another question: is it possible to make a select statement from 2 tables in different databases? 1 table is from an ORACLE db and the other table is from a SQL SERVER. If so, what is the solution? If not, is there any workaround for this problem like in the ASP level?
>
>please help! thanks