Closed. This question needs
This is the message of the error :
Impossible de résoudre le conflit de classement entre
“SQL_Latin1_General_CP1_CI_AS” et “French_CI_AS” dans l’opération
equal to.
CodePudding user response：
The problem comes from comparing two fields that do not have the same collation, so you have to specify the collation to use.
Your query should be like below :
SELECT E.EmployeeFullName, D.DepartmentId, D.Label
FROM HR.Employee AS E
LEFT JOIN HR.Department AS D ON D.DepartmentId=E.DeptId COLLATE FRENCH_CI_AS
