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
-~----------~----~----~----~------~----~------~--~---
