For the moment I solved using these query: doctorate = Session.query(Members).filter(and_(Members.removed==False, Members.tutor.has(id=tutor_id))).subquery() reports = Session.query(Reports, doctorate.c.id).outerjoin((doctorate, Reports.writer==doctorate.c.id)).order_by(Reports.id).all() # Only to obtain the objects related to the tutor reports = [reports[i][0] for i in range(len(reports)) if reports[i][1]]
Are there other possibilities? Thanks -- ------------------------------------------------------------------- (o_ (o_ //\ Coltivate Linux che tanto Windows si pianta da solo. (/)_ V_/_ +------------------------------------------------------------------+ | ENRICO MORELLI | email: more...@cerm.unifi.it | | * * * * | phone: +39 055 4574269 | | University of Florence | fax : +39 055 4574253 | | CERM - via Sacconi, 6 - 50019 Sesto Fiorentino (FI) - ITALY | +------------------------------------------------------------------+ -- 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.