get data from oracle and sql in one sql statement...

[lidds]

I will try and explain my problem as simply as I can

I have an Oracle database (external app) that contains a number of tables that I need to get data from, however I also have an SQL database that contains a number of tables that my app is using.

e.g. Oracle Table name PD_112

Structure:

ID DISP_ID
1 5
2 8
3 5

e.g. SQL Table name DispTbl

DISP_ID DESC
5 Piping
6 Electrical

What I want to do is get all the data from the Oracle table to display in a list control however I want the values in the DISP_ID column of the Oracle table to be change to the corrosponding DESC values from the DispTbl e.g. 5 from the Oracle table would display Piping instead of 5.

I know how to do this if both the tables where in one database system e.g. Oracle or SQL, however I am not sure the best why to do this when the tables are in 2 different data sources.

Below is the code for doing this in the same datasource:

SELECT PD_112.ID, DispTbl.DESC FROM PD_112 INNER JOIN DispTbl ON PD_112.DISP_ID = DispTbl.ID

I am using VB.Net 2005, just for info

Any help would really be appreshiated

Thanks

Simon