The error was not caused by the select statement, but by the where clause. Anyway, running through my code changes I notice a place where the original code created a SaleRecordset without use of " ...
Thanks for the reply!
One thing which I'd like to understand is why the code worked without errors before my changes, while it already had 2 tables with ID column in the join (since my changes invol ...
In order not to be blocked any longer I added a dirty quick-fix, by overriding SaleRecordset.GetQueryString(), and replacing "WHERE ID" with "WHERE Sale.I ...
I bought the LicenseTracker source code to do small adaptations to our needs. After extending the database model I get the error "Ambiguous column name 'ID'" when trying to access a Sale obj ...