merging tables

Discussion in 'ASP .Net' started by =?Utf-8?B?Sm9obg==?=, May 17, 2004.

  1. 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.
    =?Utf-8?B?Sm9obg==?=, May 17, 2004
    #1
    1. Advertising

  2. =?Utf-8?B?Sm9obg==?=

    Mike Bridge Guest

    Have you tried defining a DataRelation in the DataSet?

    -Mike

    On Mon, 17 May 2004 09:36:12 -0700, "John"
    <> 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..
    Mike Bridge, May 17, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Peter Bassett
    Replies:
    3
    Views:
    912
    Augustus
    Aug 15, 2003
  2. Otuatail

    Tables within tables

    Otuatail, Jul 31, 2004, in forum: HTML
    Replies:
    7
    Views:
    483
  3. Dylan Parry

    Html-tables-merging rows in a column

    Dylan Parry, Nov 25, 2005, in forum: HTML
    Replies:
    4
    Views:
    579
    Sid Ismail
    Nov 26, 2005
  4. Martin Trautmann

    XML tools for merging tables

    Martin Trautmann, May 17, 2005, in forum: XML
    Replies:
    2
    Views:
    421
    Martin Trautmann
    May 17, 2005
  5. Andrew McFarland

    Merging tables with XSLT

    Andrew McFarland, May 29, 2009, in forum: XML
    Replies:
    1
    Views:
    2,391
    Andrew McFarland
    May 29, 2009
Loading...

Share This Page