Re: Access multiple tables from diff. databases.

[Jimmy Liao <chien-wei.j.liao@AC.COM>]

Dave,

As long as they are in the same server, it's relatively easy.
Just preceed the name of the table(s) with the database name.

For example:

Begin-Select
name1 &name1
name2 & name2
from  DATABASE1..TABLE_NAME
where
End-Select

-Jimmy
(Embedded image moved to file: PIC32026.PCX)
"David M. Thelen" <ddthelen@SBBSNET.NET>
09/24/98 05:59 PM GMT
Please respond to SQR-USERS@USA.NET

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Chien-Wei J. Liao)
Subject:  Access multiple tables from diff. databases.




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

PIC32026.PCX