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 [email protected]. 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.
