This query returns 3 rows in access, but none using your trial driver.
SELECT label.name_en, dictionary.en
FROM dictionary INNER JOIN (label INNER JOIN specs ON label.ID=specs.labelID) ON dictionary.phrase=specs.data
Is this a trial limitation issue, or is the driver not capable of dealing with nested joins...?
In my test data, it works normal. You can zip and email email@example.com your test sample mdbf file.
OK, the problem is this.
I stripped down my database and now the query works. So there must be some limitation with your driver to do with the amount of records in the table.
(The query works with the ordinary jdbc driver using the BIG DATABASE, but yours doesn't!)
specs: 21484 rows
label: 572 rows
dictionary 104 rows
specs: 23 rows
label: 23 rows
dictionary 3 rows
Can you please confirm whether or not this issue is a limitation of your trial driver...?
If it works fine for SMALL DATABASE, but failed for BIG DATABASE. It means the result set limitation at here.