Thank you so much. I will try this and let you know how it works. =)
On Feb 9, 6:48 am, Manuele Pesenti <manuele.pese...@gmail.com> wrote: > Il 09/02/2012 12:33, shartha ha scritto:> how can you write a query that only > returns the dogs that Alex has? > > you can add your filter condition to the join condition usch as: > > rows = db((db.person.id==db.dog.owner)&(db.person.id==1)).select() > > If I understand the quest... > > M.