I'm wanting to create an "Execute SQL Check" in the Data Reviewer that queries a feature in my current TOC in ArcMap, based on data that comes from a layer join. I've noticed that in the Select by Attributes dialog, that it will see the joined table attributes and allow me to query off of them, however the Execute SQL Check/Query dialog does not recognize table joins that exist in the TOC. Am I missing something or is this just a limitation of this type of check?
I investigated the Table to Table check as an alternative, however the table I want to query off of is a virtual table that is generated via our ArcFM application, so there isn't a 'real' table that I can go directly too, I only have access to the data through the join that is created.
Hope that makes sense, thanks in advance for any help!
