Hey guys, I'm using web2py with mysql and I can't do a Inner Join When I try:
groups = db().select(db.groups.name,db.city.name, join=[db.groups.on(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.on(db.researcher.id == db.researcher_lab_permission.researcher_id), db.lab.on(db.lab.id == db.researcher_lab_permission.lab_id) ]) Raise this error: <class 'gluon.contrib.pymysql.err.InternalError'> (1054, u"Unknown column 'lab.group_id' in 'on clause'") But when I try only: groups = db().select(db.groups.name,db.city.name, join=[db.groups.on(db.groups.id == db.lab.group_id), db.city.on(db.city.id == db.groups.city_id) ]) It's works. There are some limit for tables join? -- 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.