Query Joined SDE Layer NOT WORKING

Discussion created by kbjsjs on Oct 14, 2013
Latest reply on Oct 14, 2013 by mvolz47
I am trying to query on a mapservice which is a Feature Class joined with another table. Both Feature Class and table are in SDE database and they are connected to SDE via direct connection. The problem is that query against this map service which is joined layer is not returning any values. If I use Application Connection instead of direct connect, then it works good. If I run a query without joining a table, it works good too. Does anyone have the same problem on querying map service which is a joined layer with direct SDE connect? I am using ArcGIS Server 10.2 and SDE database is 9.3