Re: [web2py] Re: Syntax to INNER JOIN table to itself

You're right, that should work. I wonder if there would be a significant performance hit running a LEFT JOIN in place of an INNER JOIN. I'll have to keep an eye on that to see if it makes much difference, but in my particular case (less than 100 records) I think I'll be fine. Thanks for the quic

Re: [web2py] Re: Syntax to INNER JOIN table to itself

I'm actually running off of trunk already (latest changeset is 1410 (feb4ddb2d659), committed 14 hours ago). The book example only demonstrates using with_alias in LEFT JOINs. Is this a limitation? If it makes any difference, I am running dal.py as a standalone module for a non-web2py project.