Re: [web2py] join question

Wondering if the "*belongs*" operator is what you are looking for? db((db.Relation.id == db.Role.relationid) & (db.Role.value.*belongs*(['DMV','Suggestion'])).select() Details here: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#belongs __

[web2py] join question

I have a parent (Relationship) table and a child (Role) table. Some of the child (Role) records contain the value "DMV", and other child (Role) records contain the value "Suggestion". I want to find a parent (Relationship) table that has Role children that contain both of the above values. In o