[web2py] Re: help needed for a query for one to many relation

Hi Martin, It works well, thanks Best regards, Andre On Sep 30, 2:52 pm, Marin Pranjić wrote: > On Fri, Sep 30, 2011 at 9:10 AM, arutti wrote: > > Hello, > > > I'm trying to make this simple query > > > SELECT a.*, s.* FROM account a, statement s WHERE a.nb = '2110' AND > > (a.id = s.debit OR

[web2py] Re: help needed for a query for one to many relation

After much trial and re-re-..-reading the book, I came to this solution: acc = db.account(nb=2110) # to find the account stats = db((db.statement.debit==acc.id) | (db.statement.credit==acc.id) ).select() # to find the statements Best regards On Sep 30, 9:10 am, arutti wrote: > Hello, > > I'm tr