/SQL/Sql server inner join convert collation

Sql server inner join convert collation

SELECT *
  FROM [FAEB].[dbo].[ExportaComisiones] AS f
  JOIN [zCredifiel].[dbo].[optPerson] AS p

  ON p.vTreasuryId COLLATE Latin1_General_CI_AS = f.RFC COLLATE Latin1_General_CI_AS

Similar codes

26 votes373 views2 answers
What is the sql statement that finds duplicate usernames
SQL
18 votes385 views3 answers
Mysql add column default value
SQL
0 vote350 views1 answer
Mysql check datetime equals date
SQL
0 vote346 views1 answer
Linked server delete openquery
SQL
-1 vote392 views1 answer
Search all sql tables for a value
SQL
7 votes399 views1 answer
Show line number in sql server
SQL
-2 votes380 views2 answers
Add auto_increment column to existing table mysql
SQL
0 vote347 views1 answer
Sql view index
SQL
0 vote372 views1 answer
How to change null display in psql
SQL
0 vote390 views1 answer
Split string by comma in sql server
SQL