A table window with empty rows appears when opening a table from a layer or table based on a query

Description

A feature layer or table can successfully be generated based on a query for an OLE DB connection. However, only blank rows appear when opening the table window.

Cause

Some OLE DB providers require qualification to be consistent in a query. If the query is fully qualified in one area, it must be fully qualified in all other areas. For example, the following statement fully qualifies in the where clause and when indicating the key column, but not the select clause:

Select field1
from table1
where table1.field1 > 1
Primary Key = table1.field1

The statement above will work properly for some providers, but not for others.

Solution or Workaround