It seems that the tables in join are having different collations. There are three solutions to solve this issue:
1. If possible change the database collation. 2. If possible change the server collation. 3. To allow specific queries to run despite the difference on collations, you need to modify those queries and include the COLLATE or COLLATE database_default clause when comparing string columns with different collations.