seems like "db.companies.on" should be "db.company.on" but I guess you already have that fixed.
I'd recommend to use certain naming conventions and not mix them within your db. e.g. all table names in singular (department instead of departments) and FK with _id at the end (department.company_id, subgroup.group_id, ...). Alex On Monday, February 1, 2016 at 6:37:16 PM UTC+1, Alfonso Serra wrote: > > Ok, took me a while but here it is: > > rows = db(db.company.id==1).select(db.subdepartments.ALL, join=[db. > departments.on(db.departments.id == db.subdepartments.department), db. > companies.on(db.company.id == db.departments.company)]) > > > > -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
