Problem: ODBC from MS Access (linked tables / join)

[tglynx]

Hello!

Running SQLBase 8.5.0, I linked 2 Tables from the ISLAND database in a MS Access database using the supplied 'Gupta SQLBase' ODBC Driver. I linked PUBLIC_COMPANY and PUBLIC_COMPANY_STATISTICS.

If i Query only one of the two tables everything works fine.
But the following SQL-Statement fails with an error:

------------------------
SELECT
PUBLIC_COMPANY.COMPANY_NAME,
PUBLIC_COMPANY_STATISTICS.STYLE

FROM
PUBLIC_COMPANY

INNER JOIN
PUBLIC_COMPANY_STATISTICS
ON
PUBLIC_COMPANY.COMPANY_ID = PUBLIC_COMPANY_STATISTICS.COMPANY_ID
------------------------

The error Message:
[Gupta][ODBC Driver][SQLBase]01401 DLU ICN Invalid Column name COMPANY_ID (#1401)

------------------------

What went wrong? During the installation of SQLBase i answered the Question asking if I am going to use ANSI99 SQL JOIN Syntax with 'yes'. If i try the same Query using the VB6 Sample application it works fine. So JOIN Syntax is supported.

Any suggestions?

Thanks in advance

Michael