Hi list,
I can't figure out a very simple thing. All I want is to do this
query:
select table1.A, table2.B, table3.C from table1, table2, table3 where
table1.foreignkey2 = table2.primarykey and table1.foreignkey3 =
table3.primarykey;
When rendering results, I want to be able to refer to the properties
of the joined tables:
<td>${row.A}</td>
<td>${row.table2.B}</td>
<td>${row.table3.C}</td>
My mapper looks like:
mapper(Table1, table1,
properties={
'table2':relation(Table2, lazy=False,
uselist=False),
'table3':relation(Table3, lazy=False,
uselist=False)
}
)
When I run it it creates a query with tables joined via LEFT OUER
JOIN.
How can I non-lazy (with minimal number of queries) join tables,
without LEFT OUTER JOIN? But still be able to refer to the properties
of joined tables?
Appreciate a hint.
Thanks
Ksenia.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
