join or filter, i could't join this two queries! mevcutDonem = session.query( Donem ).filter( Donem.donem_id == func.max( Donem.donem_id ).select() ).one()
konuBirimleriIds = session.query ( DonemBirimKonuMaxSayi.birim_id ).filter( and_ (DonemBirimKonuMaxSayi.konu_id == evrak.sayi.konu_id, DonemBirimKonuMaxSayi.donem_id == mevcutDonem.donem_id ) ) konuBirimIds = [] for konuBirim in konuBirimleriIds: konuBirimIds.append( konuBirim.birim_id ) konuBirimleri = session.query( Birim ).filter( and_ (Birim.parent_birim_id == 1, Birim.birim_id.in_( konuBirimIds )) ) i could't join "konuBirimleriIds" and "konuBirimleri" so i used "Birim.birim_id.in_" , how can i do it without "in_" --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---