[web2py] Re: Many to many query with two left joins - how to do in Web2py?

Grazie. This unlocks a door. I thought I had to repeat the call to left() same as the SQL. On Oct 6, 5:13 pm, Massimo Di Pierro massimo.dipie...@gmail.com wrote: Here is your SQL: SELECT purchase_orders.issue_date, purchase_orders.number, products.name FROM purchase_orders LEFT JOIN  

[web2py] Re: Many to many query with two left joins - how to do in Web2py?

Why do you left join products if you do not select anything from it? On Oct 6, 7:40 am, Cliff cjk...@gmail.com wrote: Here is the model, simplified: db.define_table('purchase_orders',     Field('issue_date', 'date',           comment = SPAN(a_comment, _style='color:orange;')),    

[web2py] Re: Many to many query with two left joins - how to do in Web2py?

Actually 'name' comes from products. Maybe it would be clearer this way: SELECT purchase_orders.issue_date, purchase_orders.number, products.name FROM purchase_orders LEFT JOIN purchase_order_products ON purchase_order_products.purchase_order_id = purchase_orders.id LEFT JOIN products ON

[web2py] Re: Many to many query with two left joins - how to do in Web2py?

Here is your SQL: SELECT purchase_orders.issue_date, purchase_orders.number, products.name FROM purchase_orders LEFT JOIN purchase_order_products ON purchase_order_products.purchase_order_id = purchase_orders.id LEFT JOIN products ON purchase_order_products.product_id = products.id