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]
