On 8/17/07, Michael Bayer [EMAIL PROTECTED] wrote:
hi Vetle -
the Table object supports a join() method, which can be called in a
chain, i.e.
table1.join(table2).join(table3)...
if you need to specify the ON part of the join, its the second
argument to join() (below illustrated with two joins back to table1):
table1.join(table2, table1.c.id==table2.c.someid).join(table3,
table1.c.id==table3.c.id)
hope this helps...
Yes thanks, it helped a little bit. I realized I could to this inside
from_obj = [ ... ]. That, in addition to using table aliases.
I ended up with something like:
t1_2 = t1.alias('t1_2')
select([t1, t1.c.a ],
from_obj = [t1.join(t1_2, t1.c.a = t1_2.c.b).join(.)]
It was kinda complicated, and the schema could have been designed a
little differently, but I got it working at last. ;)
--
Vetle Roeim
--~--~-~--~~~---~--~~
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
-~--~~~~--~~--~--~---