In a model, the Make Table View tool does not honor a query expression on a non-Spatial Database Engine (SDE) geodatabase table connection for a table with no ObjectID.
Last Published: November 21, 2016ArcGIS for Desktop
Bug ID Number
October 23, 2014
March 30, 2022
ArcGIS for Desktop
Operating System Version
2008 R2 64 Bit
After review by the development team, it has been determined that this issue is related to a known limitation with the software that lies outside of Esri's control. The issue's Additional Information section may contain further explanation.
This is a limitation of the Object Linking and Embedding Database (OLEDB).
Create an Object Linking and Embedding Database (OLEDB) connection to the table or use the Make Query Table tool instead.