Phil,
Try "db.username.tablename". If the user is an aliased dbo (ms sql) use "db.dbo.tablename".
-Mark
-----Original Message-----
From: Phill B [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 06, 2004 10:54 AM
To: CF-Talk
Subject: Query multiple databases
I need to write a join that calls to tables in different databases.
I created a user that can access both databases. I then created the
datasource in CF and it points to the DB that will be hit the most. I
then wrote the query
select a.*, b.*
from
db.tablea a
inner join
db.tableb b
Beside the fact that the join is not valid, I get an error "Invalid
object name". Any suggestions?
--
Phillip B.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- Query multiple databases Phill B
- RE: Query multiple databases Marlon Moyer
- Re: Query multiple databases Mark A. Kruger - CFG
- Re: Query multiple databases Phill B
- RE: Query multiple databases Dave Watts
- Re: Query multiple databases S . Isaac Dealey