merging tables

[Guest]

I need to select data from 2 different tables, a Microsoft Access Table on a local machine
and an Oracle table on the server
Then I need to do a left join.
What is the best way to do this

Here is what I have done
I have created two database connections, one for each of the tables
I have created a dataset that holds the two tables
So now I have two tables in a dataset
So how do I do a join on these tables?

Any help would be appreciated.

 

[Mike Bridge]

Have you tried defining a DataRelation in the DataSet?

-Mike