Dear all, I have 2 queries: 1) query1=session.query(func.max(datab.columns['counter']).label('t1')).group_by(datab.columns['site']) query2=session.query(tab.columns['name'],tab.columns['id'],tab.columns['counter']).filter(datab.columns['visits']==15)
Now I would like to get all pairs (tab.columns['name'],tab.columns['id']) having the counter attribute that satisfy query1. I tried subqueries and joins but to no avail. How to solve this? Thanks -- 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.