A single SQL statement cannot emit a query against two distinct database
connections.There are ways to get a single database connection to access
two databases behind the scenes using a technology like Oracle's DBLINK. I'm
not sure what other vendors provide for this.
This all assumes by database you mean, two different database servers. If
you mean different databases or schemas within the same server, that involves
vendor-specific configurations; check the docs for the database you're using.
On Jul 27, 2011, at 7:21 AM, Alessandro wrote:
Hi all,
I'm trying to use session to execute a query against two databases;
is it possibile?
Ex. sql:
select db1.table1.col1, db2.table2.col2
from db1.table1 inner join db2.table2 on db1.table1.key =
db2.table2.key
With sessions:
session.query(Table1).join(Table2, Table1.key==Table2.key).all()
On internet I found old answers that say it is not possible, but it
was the far 2007.. :-)
Alessandro
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.