[web2py] query on a JOIN

Hello everyone! In the example in the book for JOIN, http://web2py.com/books/default/chapter/29/6#Inner-joins how can you write a query that only returns the dogs that Alex has? I need to have access to all the fields for Alex and all the fields for the dogs he has (This is not my exact problem

Re: [web2py] query on a JOIN

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.