Forum: Ruby on Rails Join association across two databases with :through

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
22e5a5d0ff983a5eba6af7c7b81874c2?d=identicon&s=25 Bob B. (Guest)
on 2007-06-22 17:16
(Received via mailing list)

I'm trying to join two tables that are in different databases.  I
tried using :through but I'm getting complaints about trying to span
databases.  I've also tried find_by_sql and just plopped the SQL into
the function but I get complaints about one user not being able to
access the other database.  I know I could just make both databases
accessible by the same username/password pair but, besides being
hacky, I don't have control of the databases.

Thanks for any help you can give me on this,
This topic is locked and can not be replied to.