I think this should be it: query=db((db.things.id>0)&(db.photos_things.id==db.photos_things.thing_id)).select()
for row in query: list = [row.things.title, row.photos_things.photo_id.image]
I think this should be it: query=db((db.things.id>0)&(db.photos_things.id==db.photos_things.thing_id)).select()
for row in query: list = [row.things.title, row.photos_things.photo_id.image]