I have no immediate use for it. However, basing queries off of sub-queries(sub-table) happens a lot in the ms-access world.
-- Thadeus On Tue, Apr 13, 2010 at 1:08 PM, mdipierro <mdipie...@cs.depaul.edu> wrote: > It would be difficult but possible. Is this a priority? > > On Apr 13, 10:20 am, Thadeus Burgess <thade...@thadeusb.com> wrote: >> Interesting, what would be the possibility of adding this as a feature >> to the new dal? >> >> -- >> Thadeus >> >> On Tue, Apr 13, 2010 at 5:06 AM, canna <c.ne...@gmail.com> wrote: >> > Hello everybody! >> >> > I really need help with a query I'm trying to execute in Web2Py DAL >> > is there a way to use an inline table in the FROM field of a query? >> >> > this is my query: >> >> > SELECT SUM( HoursWorked / DayHoursSum ) AS DaysWorked >> > FROM `Tasks_TimeLog` H, ( >> >> > SELECT TheDate, User_id, SUM( HoursWorked ) AS DayHoursSum >> > FROM `Tasks_TimeLog` >> > GROUP BY TheDate, User_id >> > )S >> > WHERE H.User_id = S.User_id >> > AND H.TheDate = S.TheDate >> > AND Task='2' >> > GROUP BY Task >> >> > this is the inline table in Web2py: >> >> > inlineTable=db()._select(db.Tasks_TimeLog.TheDate,db.Tasks_TimeLog.User_id,db.Tasks_TimeLog.HoursWorked.sum(),groupby=db.Tasks_TimeLog.TheDate| >> > db.Tasks_TimeLog.User_id) >> >> > how do I use the inline table in my full query?? >> >> > rows=db(db.Tasks_TimeLog.Task=='2'.....).select(.....,groupby=db.Tasks_TimeLog.Task) >> >> > Thanks to all the helpers!! > > > -- > To unsubscribe, reply using "remove me" as the subject. >
