Date:         Wed, 30 Dec 1998 12:51:39 PST
Reply-To:     David Collins <david_collins@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         David Collins <david_collins@HOTMAIL.COM>
Subject:      Oracle Connect:  2 table join from separate databases?
Content-Type: text/plain

Does anyone know how to join 2 tables from separate databases using
Oracle Connect?  I found nothing on the Web or in books in handling this
using Connect.
 
I know, by example, how to join two tables from the SAME database in SQL
within Oracle.
 
        Here is the 2 table join from one database:
 
 
        proc sql noerrorstop;
           connect to oracle(user=scott password=tiger path='@abc1');
        select * from connection to oracle
          (select emp.ename, emp.empno, emp.job, emp.deptno,
                  dept.deptno, dept.dname, dept.loc
           from emp, dept where emp.deptno=dept.deptno);
 
 
D.Collins
FUNB
Charlotte, NC
 
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com