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'