I think you have to define 2 db objects. 1) Retrieve data from db1. 2) For each row, retrieve data from db2 and construct your own rows object.
But maybe somebody has a better solution. -- Vinicius Assef. On Thu, Dec 1, 2011 at 9:40 PM, Jim Gregory <[email protected]> wrote: > I have a legacy database that my app needs to connect to. The data in > my app's table has a many-to-one relationship with the data in the > legacy database's table. I'd like to retrieve records from my app's > table plus the data associated with that record from the legacy > database's table at the same time. What's the best way to do this? > It doesn't appear I can make joins across databases. >
