In ArcGIS Pro, the Select By Attributes tool does not display the options for choosing fields instead of values after performing multiple table joins to a polygon layer.

Additional Information

Workaround

This issue only recognizes fields sometimes. Fill in the expression with '!Table!field!' to accept the fields. For example:

Where: ID_2 is equal APN_Match_ALL_UPPERCASE.TAB.APN

*The SQL expression is valid.

Steps to Reproduce