Added "name" column to Join1 to test the case of some columns needing aliases (because they appear in two tables) and some not needing them but getting them anyway.  This behaves oddly in MS Access, so modified the rest of the architecture to properly handle this case.  In the course of implementing this, discovered that order by count(*) was not working with MS Access, so added tests for that and fixed it.
Added "name" column to Join1 to test the case of some columns needing aliases (because they appear in two tables) and some not needing them but getting them anyway.  This behaves oddly in MS Access, so modified the rest of the architecture to properly handle this case.  In the course of implementing this, discovered that order by count(*) was not working with MS Access, so added tests for that and fixed it.

azavea/net-dao-sqlserver