Yes, thanks Massimo! The first error pass, but now: <class 'gluon.contrib.pymysql.err.InternalError'> (1054, u"Unknown column 'researcher.user_id' in 'on clause'")
How could I generate sql to debug it? 2013/10/28 Massimo Di Pierro <massimo.dipie...@gmail.com> > > groups = db().select(db.groups.name,db.**city.name <http://db.city.name/> > ,db.auth_user.email,db.researcher.with_alias('name1').ALL, db.lab. > with_alias('name2').ALL, > > > join=[db.groups.on(db.groups.**id<http://db.groups.id/> == > db.lab.group_id), > db.city.on(db.city.id == > db.groups.city_id), > db.auth_user.on(db.researcher.**user_id == > db.auth_user.id), > db.researcher.with_alias('name1').on(db.** > researcher.id <http://db.researcher.id/> == db.researcher_lab_permission.* > *researcher_id), > db.lab.with_alias('name2').on(db.lab.id == > db.researcher_lab_permission.**lab_id) > ]) > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.