[web2py] SQLFORM.grid with multiple LEFT OUTER JOINs

[Jim S]

Is there a way to specify 2 left outer joins for a SQLFORM.grid?

I tried this:

query = (db.feedLoad.deliverOn==datetime.datetime.today())&(
db.feedLoad.siteId==1)

fields = [db.feedLoad.siteId, db.feedOrderLine.productSiteId, 
db.feedLoad.deliverOn, db.feedLoad.loadNumber, 
db.feedOrder.customerName, db.feedOrder.customerCityState,
db.feedOrder.dropShipName, db.feedOrder.dropShipCityState,
db.feedLoad.driverId, db.feedOrder.orderNumber,
db.feedOrderLine.productNumber, db.feedOrderLine.productName]

left = 
db.feedOrder.on(db.feedLoad.feedLoadId==db.feedOrder.feedLoadId).db.feedOrderLine.on(db.feedOrder.feedOrderId==db.feedOrderLine.feedOrderId)

grid = SQLFORM.grid(query, left=left)

This works but I get WAY more records than I should

--