Looks like you specify the left relation also in the select clause. Debugging tip: you can use _select() to see the SQL generated by the DAL. To get answers in the forum, it helps if you convert your question to an minimal example using easy to grasp tablenames and relations.
Nico de Groot -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
