If you are running D3-Linux 7.4.2 and above, D3-NT 7.5 and above and
you use INDEX items on your files, there is a BUG when using ODBC

If you JOIN 2 or more TABLES together and the fields you select from
the tables include those that have INDEXES attached, the ODBC driver
will fail to return ALL the data requested

RD are aware of this, and there is an ACTION ITEM logged.

The "fix" for now is to remove your INDEX


John