Hi,
I've a query as follows: -
elements_pending = db(db.client_delegate.id==request.args(1))\
(db.client_delegate.client_role_id==db.client_role.id)\
(db.role_element.client_role_id==db.client_delegate.client_role_id)\
(db.client_delegate_assessment.role_element_id==db.role_element.id).select()
...but which i need to make a left out join, such that
"client_delegate_assessment" will be shown if present, but I'm having
problems figuring out how to change the code above.
I've used "executesql" for now, but I'd like to get my head around this
because it's making me feel silly!
--
Regards,
PhilK
'a bell is a cup...until it is struck'
