Hello, Ksenia, This may help:
http://www.sqlalchemy.org/docs/05/mappers.html#advdatamapping_relation_strategies_containseager On Sep 29, 2:38 am, Ksenia <[EMAIL PROTECTED]> wrote: > 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 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 -~----------~----~----~----~------~----~------~--~---
