How to use the COLLATE in a JOIN in SQL Server?
<p>I´m trying to join two tables but I get this error:</p>

<blockquote>
  <p><em>Msg 468, Level 16, State 9, Line 8 Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and
  "Latin1_General_CI_AS" in the equal to operation.</em></p>
</blockquote>

<p>This is the code I´m using:</p>

<pre><code> SELECT *

  FROM [FAEB].[dbo].[ExportaComisiones] AS f

  JOIN [zCredifiel].[dbo].[optPerson] AS p

  ON (p.vTreasuryId = f.RFC) COLLATE Latin1_General_CI_AS 
</code></pre>

<p>I know it is wrong, it underlines <strong>COLLATE</strong>. I do not know how to apply it. </p>