Why do you left join products if you do not select anything from it?
On Oct 6, 7:40 am, Cliff <[email protected]> wrote: > Here is the model, simplified: > > db.define_table('purchase_orders', > Field('issue_date', 'date', > comment = SPAN(a_comment, _style='color:orange;')), > Field('number', length=24, requires=IS_NOT_EMPTY(), > required=True, notnull=True, > comment=SPAN('Required', _style='color:orange;')), > Field('closed', 'boolean', readable=False, writable=False, > default=False), > format = '%(number)s' > ) > db.define_table( 'products', > Field('name', length=256, required=True, notnull=True), > Field('internal_item_number', length=36), > format = '%(name)s' > ) > db.define_table('purchase_order_products', > Field('purchase_order_id', db.purchase_orders), > Field('product_id', db.products), > Field('quantity', 'decimal(12,3)'), > ) > > in SQL I can make this query: > SELECT issue_date, number, 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 > > How do I do this in Web2py?
