Getting Data type mismatch error in Union Queries. Although I tried all the solution (Links) provided on net but still not able to solve this issue. Main thing is that we have only one field in query from the comparison of two fields. as in below error we have only Sales Name in "SmmActiitiesAssociation".
Just because of this error we are not able to Sync and Compile Data Dictionary fully.
Synchronize database There is a field mismatch in the union query. Field SalesName is not compatible with field Description.