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
-~----------~----~----~----~------~----~------~--~---

Reply via email to