merging tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Back
Top