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
WHERE specs.modelID=462;
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 webmaster@hxtt.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!)
Please Advise...!
BIG DATABASE
specs: 21484 rows
label: 572 rows
dictionary 104 rows
SMALL DATABASE
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.
|
Main
webmaster@hxtt.com