Ouch I thought it's within the same database. Sorry.
On Dec 2, 10:19 am, Vinicius Assef <[email protected]> wrote: > 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.
