SyntaxFix

[sql-server] How to use the COLLATE in a JOIN in SQL Server?

Correct syntax looks like this. See MSDN.

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

Examples related to sql-server

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Count the Number of Tables in a SQL Server Database • Visual Studio 2017 does not have Business Intelligence Integration Services/Projects • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database • How to create temp table using Create statement in SQL Server? • SQL Query Where Date = Today Minus 7 Days • How do I pass a list as a parameter in a stored procedure? • SQL Server date format yyyymmdd

Examples related to join

• Pandas Merging 101 • pandas: merge (join) two data frames on multiple columns • How to use the COLLATE in a JOIN in SQL Server? • How to join multiple collections with $lookup in mongodb • How to join on multiple columns in Pyspark? • Pandas join issue: columns overlap but no suffix specified • MySQL select rows where left join is null • How to return rows from left table not found in right table? • Why do multiple-table joins produce duplicate rows? • pandas three-way joining multiple dataframes on columns

Examples related to collate

• How to use the COLLATE in a JOIN in SQL Server? • Change collations of all columns of all tables in SQL Server