Hi Marin,

On 31/10/2011 18:31, Marin Pranjić wrote:
As described here:
http://web2py.com/book/default/chapter/06#Left-Outer-Join

db(inner_joins).select(select_fields, left = db.tablename.on(...))

note that "left" can be a list of joins if you need >1 left join in query.

left = [db.table1.on(...), db.table2.on(...), ...]


Thanks - I'll experiment with that. The list of joins idea makes more sense to me.

FWIW, after I'd taken a break, I realised that I could take a couple of tables out of my example and was able to use the left outer join in that simpler case.


--

Regards,

PhilK


'a bell is a cup...until it is struck'

Reply via email to