title: How to use COLLATE in a JOIN in SQL
body: <p>I´m trying to join two tables but I get this error:</p>
  
  <blockquote>
    <p>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.</p>
  </blockquote>
  
  <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>