jdbc:ucanaccess sql query with subquery does not work

[Thomas Pelzer]

Under Java I am using the maven dependency ucanaccess 4.0.4.
Query containing a "... and exists (select ... ) does not bring an error but also no result
Query works directly in an Access DB sql query without any problem

the sub select inside my exists joins also to tables of my main query. So maybe this is the problem ?

if I do a simple exists with "and exists ( select 1 from tabA where tabA.field = 1 ) it seems to work.

any idea ?
Thanks
Thomas

[Gord Thompson]

Can you provide a minimal reproducible example? Specifically, what do you mean by "the sub select inside my exists joins also to tables of my main query"?