call subquery() on konuBirimleriIds and use the .c. attribute on the resulting selectable to locate columns with which to join from. technique is identical to the example here: http://www.sqlalchemy.org/docs/05/ormtutorial.html#using-subqueries
ibrahim.z.hi...@gmail.com wrote: > > 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 -~----------~----~----~----~------~----~------~--~---