Re: retrieve data from 2 database
- From: Steve Holden <steve@xxxxxxxxxxxxx>
- Date: Thu, 28 Jul 2005 21:33:15 +0100
crespoh wrote:
Well, a lot depends on the database. If it's two Access .mdb files, for example, or two different databases in a single SQL Server instance, sometimes you can use SQL statements that cross-refer. Not possible with ODBC, though, I fear.Hi,
How do I select data from two tables from two different databases and compare them? using dbi,odbc
In that case, we have to hope that the datasets are small enough to hold in memory, as Python data structures, and then operate on them as Python sets or some such. The DB API delivers the results of queries as lists of tuples, each tuple representing a row, but of course they can easily be transformed into other Python objects with more convenient properties to join the two sets together.
Much then depends on how you want to join the two sets.
regards Steve -- Steve Holden +44 150 684 7255 +1 800 494 3119 Holden Web LLC http://www.holdenweb.com/
.
- References:
- retrieve data from 2 database
- From: crespoh
- retrieve data from 2 database
- Prev by Date: Re: Ten Essential Development Practices
- Next by Date: Re: pySerial Windows write problem
- Previous by thread: Re: retrieve data from 2 database
- Next by thread: how to get function signature
- Index(es):
Relevant Pages
|
