Re: [web2py] using inline tables in the query (subquery in the FROM field)

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

[web2py] using inline tables in the query (subquery in the FROM field)

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