I need these joins because I need filter some tables without selecting all the tables and filtering with where. Anyway, I tried:
rows = (db.groups.id == db.lab.group_id)(db.lab.id == db.researcher_lab_permission.lab_id)(db.researcher.id == db.researcher_lab_permission.researcher_id)(db.researcher.user_id == db.auth_user.id).select(db.groups.name,db.city.name,db.auth_user.ALL) And it returns: <type 'exceptions.TypeError'> 'Query' object is not callable I'm using db.executesql and it's working: db.executesql('''SELECT l.id,g.name,c.name FROM researcher_lab_permission as rl JOIN lab as l JOIN researcher as r JOIN auth_user as a JOIN groups as g JOIN city as c ON rl.researcher_id = r.id AND rl.lab_id = l.id AND a.id = r.user_id AND l.group_id = g.id AND c.id = g.city_id WHERE a.id = %s''' %(auth.user_id)) Something strange with DAL... 2013/10/28 Massimo Di Pierro <massimo.dipie...@gmail.com> > (db.groups.**id <http://db.groups.id/> == db.lab.group_id)(db.lab.id == > db.researcher_lab_permission.**lab_id)(db.**researcher.id<http://db.researcher.id/> > == db.researcher_lab_permission.**researcher_id)(db.researcher.**user_id > == db.auth_user.id).select(db.groups.name,db.**city.name<http://db.city.name/> > ,db.auth_user.ALL) -- 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.