On Apr 30, 2007, at 8:13 AM, VN wrote:
>
> I tried to get this to work but did not succeed. Suppose I have two
> databases dbA and dbB which have one table each dbAtbl and dbBtbl.
> Both tables have a column id on which I would like to perform a join.
>
> import sqlalchemy as SA
> md_dbA=SA.BoundMetaData('dbA')
> tbl_dbAtbl=SA.Table('dbAtbl',md_dbA,autoload=True)
>
> SA.text("ATTACH DATABASE 'C:Temp\dbA.db' as dbA_db")
>
> How can I now perform the join? I am not able to see dbBtbl.
you might need to use a Table with a "schema='dbA_db'", just a
guess. look at the echoed sql and see if it matches things that work
at the sqlite console.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
