Re: Access multiple tables from diff. databases.

["Derry, Denny" <Denny.Derry@NMB.NORWEST.COM>]

     You can access any database/column that is on the same SQL server you
     are running your SQR report against. Syntax is :

        select x
        from {database}.{owner}.{table_name}

     So if you have database a owned by dbo with table t, and database b
     owned by dba with table u the syntax is :

     select x, y
     from a.dbo.t, b.dba.c
     where a.dbo.t.column_name = b.dba.u.column_name

     -Denny


______________________________ Reply Separator
_________________________________
Subject: Access multiple tables from diff. databases.
Author:  David M. Thelen [SMTP:ddthelen@SBBSNET.NET]  at NMB
Date:    09/24/1998 12:59 PM


When running an sqr through PS process scheduler is it possible to
access other tables outside of the Peoplesoft database that I'm logged
into.  Can I access other SQL server tables or even MS Access tables?
If so, how do I make the connection?

MS SQL Server
SQR 3.0
PeopleSoft 6.0

Thanks