Hi, I have some questions about SqlAlchemy. 1.
I know I can define a relation on a Class and load records of the relation in only one select (eager loading), but I see SqlAlchemy uses a LEFT OUTER JOIN to join. If I would filter records by a WHERE CLAUSE on a relation, I would like to have an INNER JOIN, instead. How can I have an INNER JOIN ? Also, how can I specify a WHERE CLAUSE on a relation ? For Example: Class Orders: ..... Class OrderLine: .... SELECT .... FROM Orders INNER JOIN OrderLine ON ..... WHERE OrderLine.item = 'bicycle' 2. I would like to join tables that are stored into different databases. How can I do this ? For example: Orders on database 1 OrderLines on database 2 Thanks, Stefano --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---