SELECT tb1.id, tb2.name
FROM db1..table1 tb1, db2..table2 tb2
?
-----Original Message-----
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 12:22 PM
To: CF-Talk
Subject: Re: SQL SP
>Hi all
>
>Hope someone can help me with this:
>
>How can I tell a SP to query a different dbs inside of a SP?
>
>I need to be able to run some queries on one db and within that same SP run
>queries on another db.
>IS this possible? Or will I need to do two different SP one in each db and
>a temp table to hold the information from the first SP to run against the
>second SP.
>and just do the two calls from the CF page?
>
I don't know what RDBMS you're using, but you should be able to scope the
table name with either the database name or the schema name:
myDB1.tableName, myDB2.tableName, etc.
Regards,
Dave.
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
