Inner joins between two different databases?! I understood Jim were talking about a lagacy database and his app database. Two different db's.
If we're talking about the same database, I'm with you, lyn2py. -- Vinicius Assef. On Thu, Dec 1, 2011 at 11:35 PM, lyn2py <[email protected]> wrote: > Definitely possible. > > Take a look at the examples here: > http://web2py.com/book/default/chapter/06#Inner-Joins > > On Dec 2, 7:40 am, 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. >
