I am able to resolve the similar issue by creating the view using **Create from query** option under the configured data source. To do this, I followed below steps:
* In Virtual DataPort, select the configured data source and click the create from query.
* In “Create from query”, use the query with sql server "COLLATE Latin1_General_CI_AS" on the join condition to ensure character set match.
Now, I was able to obtain the results as expected when I execute the base view created from query.
For more information, you can refer to the [Creating Base Views from SQL Queries](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#creating-base-views-from-sql-queries) section of the Virtual DataPort Administration Guide.
Hope this helps!