I'm still learning web2py, so bear with me. I am trying to write a somewhat complex query and would like to build it as a series of smaller, easier to understand queries. web2py seems to support this beautifully for INNER JOINs and WHERE clauses as explained here: http://www.thadeusb.com/weblog/2010/3/19/increase_productivity_by_using_parameterized_queries_with_web2py
However, it appears that LEFT JOINs are not supported in the same way, because they are only available from within the .select() method. I tried doing this and received the following error: TypeError: 'SQLJoin' object is not callable Is there any sort of workaround or am I stuck creating my left joins when I call .select()? Thanks, Mike
