I see what you mean.
When I removed the '_evw' from the query, it worked.
Unfortunately, I'd rather see the edits in real time.
I might end up going with a spatial database view, which will allow me to see these real time.
The spatial database view would be something along the lines of the following when trying to symbolize a feature class from the attribute fields of a table:
CREATE VIEW TestAndresMaxDateEquals AS SELECT ss.OBJECTID AS 'FC_LONGINTEGEROID', ss.GlobalID AS 'FC_Global_ID', ss.SHAPE AS 'ESRI_Shape', ssh.InsStatus AS 'Inspection_Status', ssh.REPSTATUS AS 'Repair_Status', ssh.CONDITION_GENERAL AS 'General_Condition', ssh.InsStart AS 'Inspection_Date_Time', ssh.ParentGUID AS 'Parent_GUID' FROM Sanitary.sde.ssManholeInspections_evw AS ss JOIN Sanitary.sde.ssManholeInspectionsHistory_evw AS ssh ON ss.GlobalID = ssh.ParentGUID WHERE ssh.InsStart = (SELECT MAX(ssh2.InsStart) FROM Sanitary.sde.ssManholeInspectionsHistory_evw AS ssh2 WHERE ssh2.ParentGUID = ssh.ParentGUID)
Caveats:
1.
I will have to register the FC and Table involved in this view as versioned with the option to move edits to base, which may not detect conflicts on the edits.
I am willing to overlook this because I think conflict would be minimal in my application.
2.
So that my application can see the edits real-time, I will publish the source mxd with the layers pointing to the default version.
I will update this if I decide something else here, and in my post:
https://community.esri.com/thread/215046-symbolizing-feature-class-using-related-table-values
Please let me know if you see any weaknesses in my query.
I can't thank you enough Joshua for your help.
EDIT:
I am debating whether or not to replace the '=' operator with the 'in' operator for the subquery in my query statement.
Any feedback?