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
