Hi FYI, an update on this. I have opened a support track. It highlighted a problem with the driver provided by our database vendor. The vendor provided us with a hotfix and that fixed the original problem. However, it uncovered a limitation of the SAS/ACCESS JDBC and ODBC interfaces. They do not support mixing outer with inner joins. In that case the queries are broken down in multiple sub-queries sent to the database, which causes a lot of problems for us. I have opened a SAS ballot to request an enhancement to support that outer/inner join mixing - or at least to give a flag to indicate that the underlying data source supports inner and outer joins together. You're obviously all welcome to upvote it 😊 https://communities.sas.com/t5/SASware-Ballot-Ideas/JDBC-SAS-ACCESS-More-options-for-query-pushdown-generation/idi-p/803061 Thanks for your help !
... View more