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.
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:
where table1.field1 > 1
Primary Key = table1.field1
The statement above will work properly for some providers, but not for others.
Be consistent with qualification throughout the query. If the query performs a join, fully qualify table and column names.
If a * is used in the select clause, the fields are interpreted as fully qualified if the query performs a join. Otherwise, they are interpreted as unqualified.