[web2py] Re: joins, geraldo and possible alias

I tried it with sqlexecute but I would need to do quite a lot of processing on the results... Is there any work around you can think of? Is there any way to use the DAL with a select statement in the format generated from _select? Thanks, J On Mar 23, 9:35 pm, jonatron wrote: > I get

[web2py] Re: joins, geraldo and possible alias

ndledBy)]) > > On Mar 23, 11:31 am, jonatron wrote: > > > Thanks, > > > This is close, but it does not quite get the result I'm looking for, I > > basically need the following MySQL query: > > > SELECT Calls . * , created_by.Name, handled_by.Name >

[web2py] Re: joins, geraldo and possible alias

, >    left=[created_by.on(created_by.id==db.Calls.CreatedBy), >            handled_by.on(handled_by.id==db.Calls.HandledBy)]) > > On Mar 20, 6:58 am, jonatron wrote: > > > Hi, > > > I am hoping someone can help with this: > > > I have tables setup something

[web2py] joins, geraldo and possible alias

Hi, I am hoping someone can help with this: I have tables setup something like this (this is a simplified representation): db.define_table('Users', Field('Name')) db.define_table('Calls', Field('CallerName'), Field('CreatedBy', db.Users), Field('HandledBy', db.Users)) I need to produce a query