the whole point of left= is to trigger a LEFT OUTER JOIN that by design reports ALL the elements of the left table and only the elements that matches of the right table.... If you don't want this functionality then left= is not good for your usecase
On Thursday, April 11, 2013 4:23:12 PM UTC+2, Annet wrote: > > I have the following code: > > > rows=db(db.node.computedSubClass!=SC_CONSUMER).select(db.node.ALL,db.groups.ALL,left=db.groups.on(( > db.node.id==db.groups.nodeID)&(db.groups.type!=RELATEDNAMES))) > > I'd hoped that this would exclude groups of type RELATEDNAMES of rows, > however, the code sets all fields of db.groups.ALL to None and includes > them in rows. > > How do I get rows without groups of type RELATEDNAMES using a left join. > > > Kind regards, > > Annet > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
