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. (Speaking of using it as a standalone module, I almost wet myself when I saw how easy it was to use it that way. Nice work on the re-write.) Thanks, Mike On Tue, Dec 21, 2010 at 5:00 PM, mdipierro <mdipie...@cs.depaul.edu> wrote: > there is a bug in 1.90.6 about with_alias. I think it is fixed in > trunk. give it a try. > > On Dec 21, 3:46 pm, mwolfe02 <michael.joseph.wo...@gmail.com> wrote: > > 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 >
