By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,666 Members | 1,924 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,666 IT Pros & Developers. It's quick & easy.

merging tables

P: n/a
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.

Nov 18 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Have you tried defining a DataRelation in the DataSet?

-Mike

On Mon, 17 May 2004 09:36:12 -0700, "John"
<an*******@discussions.microsoft.com> wrote:
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..


Nov 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.