title: Cannot-resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/1607560/cannot-resolve-the-collation-conflict-between-sql-latin1-general-cp1-ci-as-and">Cannot resolve the collation conflict between &ldquo;SQL_Latin1_General_CP1_CI_AS&rdquo; and &ldquo;Latin1_General_CI_AS&rdquo; in the equal to operation</a>  </p>
  </blockquote>
  
  
  
  <p>When I try to join two tables on the same column a.C1=b.C2 I get this message:</p>
  
  <p>Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.</p>
  
  <p>Can you tell me please is there any way to join them without changing the collations in tables?</p>
  
  <pre><code>SELECT * FROM
  BIT_Dashboard.dse.Solution a
  INNER JOIN
  Leistungsportfolio.dbo.EBFHB_Jobliste b
  ON a.Solution_NAM = b.SolutionName
  WHERE a.Solution_NAM COLLATE DATABASE_DEFAULT = b.SolutionName COLLATE DATABASE_DEFAULT
  </code></pre>
  
  <p>Error Msg: "Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation."</p>