db.define_table('things',
Field('title', 'string'),
)
db.define_table('photos',
Field('thing_id', db.things),
Field('photo', 'upload'),
)Is there a way to get all things and just one photo per thing? Something like: rows = db(db.things.id>0).select(db.things.ALL, db.photos.ALL, left=(db.photos.on(db.things.id==db.photos.things_id))).remove_repeated_things()
