Hello Michael, the query is perfect, with every JOIN and LEFT JOIN, thank you very much. jo
Michael Bayer ha scritto:
hey jose - was waiting to see if anyone jumped on this for you. alas, no responses. making some assumptions about your Table objects, your query above would look something like (forgiving my occasional misspellings of italian words): select([operatore.c.id, anagrafica.c.nome], and_(acl.c.cod_ruolo=='vet', operatore.c.data_fine_attivita==None), from_obj=[operatore.join(anagrafica, operatore.c.id_anagrafica==anagrafica.c.id).outerjoin(acl, acl.c.id_operatore==operatore.c.id)], distinct=True, order_by=[operatore.c.id, anagrafica.c.nome])
--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
