Actually, I finally figured this out with the help of the people on IRC. Sorry for the noise.
On Jun 25, 1:21 pm, Mike <[email protected]> wrote: > Hi, > > I'm sure this is a simple question, but my Google-fu has failed me. I > need to convert the following into a sqlalchemy query and I just can't > seem to get it right: > > SELECT > ACTHD.HOURTYPE, > sum(ACTHD.HOURS), > sum(ACTHD.AMT) > FROM myDatabase.dbo.TableOne ACTHD INNER JOIN > myDatabase.dbo.TableTwo HOURR ON ACTHD.HOURTYPE = HOURR.HOURTYPE > where ACTHD.CHK_DOC_NO=13880 > GROUP by ACTHD.HOURTYPE > > I figured out the join part from the docs: > > qry = session.query(TableOne, TableTwo).filter(TableOne.HOURTYPE == > TableTwo.HOURTYPE) > > And I know you get the "sum" command from the "func" module, but how > do I combine these? > > I am using SqlAlchemy 0.5.4p2, Python 2.5 on Windows XP against MS SQL > Server 2000. > > Thanks! > > Mike --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
