merging tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John (anonymous_at_discussions.microsoft.com)
Date: 05/17/04 

Date: Mon, 17 May 2004 09:36:12 -0700

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

Relevant Pages

  • Re: Access error on citrix environment only.
    ... Recently I migrated a MS Access app from mdb data tables to oracle db. ... citrix for only two screens with below error. ... Possibly the Citrix server has a different version of the Oracle driver software or ... Tony Toews, Microsoft Access MVP ...
    (comp.databases.ms-access)
  • [NEWS] Multiple Vulnerabilities in Oracle Database (Character Conversion, Extproc, Password Disclosu
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Multiple vulnerabilities were discovered in the (Oracle database server ... password is required to exploit this vulnerability. ...
    (Securiteam)
  • Re: How to make your report run faster
    ... I've done no work with Oracle as the Server DB, ... > if they click the listbox then "Preview report" button is enabled. ... > -I was try to make the old queries for subreport, ...
    (microsoft.public.access.reports)
  • Re: I cant find a SETUP.EXE in the SQL Plus Client ??
    ... someone else's server for testing some SELECT statements I'm ... free client because I don't own the Oracle license. ... SQL statements. ... There is no documentation with that download. ...
    (comp.databases.oracle.tools)
  • RE: sunmanagers Digest, Vol 44, Issue 20
    ... diagnostics from the front-panel. ... Any ideas on what the problem may be or how to get this server powered ... The cluster itself is working, but I'm unable to shut down the nodes. ... Oracle uses shared memory for the communication between the client ...
    (SunManagers)