you could set up your oracle server as a linked server in SQL

you can then create a view in your SQL server that does the join for you.

ou can then just connect to the SQL server from ASP and load the recordset