[web2py] Recursive select up to 2 levels

[Cahya Dewanta]

Hello. Here's how I define my models:

db.define_table('owner', Field('name'), format='%(name)s')
db.define_table('retail', Field('owner_id', db.owner), Field('name'),
format='%(name)s')
db.define_table('administer', Field('retail_id', db.retail),
Field('name'))

How can I select all administers belong/related to a specified owner?

Thank you so very much.