This is definitely a bug, the solution doesn't seem easy, The problem is that it should not apply the common filters on the alias used on the left join again as they are already applied on the left join ON query itself. Please file an issue here: https://github.com/web2py/pydal/issues
-- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.

