On May 16, 2009, at 3:42 PM, stud200...@gmail.com wrote:
>
> I'm having some problems using join operation and I'd like to confirm
> if I use it properly. I do it this way(for 3 tables in which table A
> has keys to other tables):
>
> someMappedTableA.join(someMappedTableB, someMappedTableA.c.BID ==
> someMappedTableB.ID).join(someMappedTableC, someMappedTableA.c.CID ==
> someMappedTableC.ID)
that's the correct form for joining Table objects, but I see you
aren't calling ".c." on every entity there (TableB.ID, TableC.ID) -
the targets of the join must also be Table objects (in which case you
must call .c.ID).
If you're joining from Query(), thats something different.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---