db.define_table('things',
Field('title', 'string'),
)
db.define_table('photos',
Field('title', 'string'),
Field('image', 'upload', autodelete=True),
)
db.define_table('photos_things',
Field('thing_id', db.things),
Field('photo_id', db.photos),
)
Is there a way to get all things and one photo per thing with 1 query?
