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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
