Re: Joining tables from two separate oracle databases possible

From: Darryl <nospam_at_nospam.com>
Date: Thu, 01 Mar 2001 08:17:57 GMT
Message-ID: <VAnn6.4329$%4.466102@newsread1.prod.itd.earthlink.net>

Will,

One way you can definitely do it is through MS Access - I've done it many times. You'll need separate ODBC datasources on the computer. In the Access database, create links to the tables, then build the join query as you normally would.

Darryl

"Will Kramer" <willardkNOSPAM_at_email.com> wrote in message news:3a9d5b92.531442353_at_News.CIS.DFN.DE...
> I'm have oracle 8.1 client installed on my NT box and two databases I
> have access to via tcp/ip and mention in tnsnames.ora. Is there a way
> via sql to access both databases at the same time and do a simple
> join...like lastname to lastname???
>
> If not are there ways of doing this? do I need third party software?
>
>
> any help , or directions to the right spot would be greatly
> appreciated.
>
> regards,
> Will Kramer
>
>
Received on Thu Mar 01 2001 - 02:17:57 CST