I just do what the book says and it works; so I use the binary and operator between terms. Also you can split it across lines. Since I use descriptive (meaning too long) table and field names, it's helpful to be able to split.
On Jul 28, 12:02 pm, pbreit <[email protected]> wrote: > What was the final answer on creating compound queries like this: > > db(db.requests.product==db.products.id)(db.products.id==3).select() > > Is that acceptable or advisable? Or is the & way preferred? The & way has > the benefit of being splittable across lines? > > Also, I think Field('product', db.product) is pretty common, at least in > web2p (vs Field('product_id', db.product)).

