[web2py] Syntax to INNER JOIN table to itself

[mwolfe02]

I have a legacy table with a three-character primary key and a three-
character self-referencing field.  I'm trying to implement the
following sql using the DAL:

SELECT District.Description, SchoolDistrict.Description
FROM District.DistrictID
INNER JOIN District AS SchoolDistrict
ON District.SchoolDistrictID = SchoolDistrict.DistrictID

I thought I could use with_alias to do this but it does not seem to be
working.

Thanks,
Mike