I recently upgraded to ArcGIS Desktop 10.7 and saved an MXD in version 10.7 that contains a join between a GIS layer (on SDE) and a view (on a SQL Server database). When publishing the 10.7 MXD version as a map service, the join to the view gets dropped.
The work-around for now is to save the MXD as version 10.3 and publish the map service.
Question: Is there another solution?
