title: SQL Error with "Turkish_CI_AS" and "SQL_Latin1_General_CP1_CI_AS"
body: <p>I have a SQL query like this:</p>
  
  <pre><code>SELECT E.HESAP, B.TEKLIF_NO1 + '/' + B.TEKLIF_NO2 AS 'TEKLIF',
      E.MUSTERI,CONVERT(VARCHAR(10),B.ISL_TAR,103) AS 'TARIH', SUM(
      ISNULL(CAST(B.ODENEN_ANAPARA AS FLOAT),0)+ISNULL(CAST(B.FAIZ AS FLOAT),0)+
      ISNULL(CAST(B.BSMV AS FLOAT),0)+ISNULL(CAST(B.GECIKME_FAIZ AS FLOAT),0)+
      ISNULL(CAST(B.GECIKME_BSMV AS FLOAT),0)) AS 'YATAN', 
      (CASE WHEN C.DOVIZ_KOD = 21 THEN 'EUR' WHEN C.DOVIZ_KOD = 2 THEN 'USD' WHEN C.DOVIZ_KOD = 1 THEN 'TL' END) AS 'KUR',
      E.AVUKAT, CONVERT(VARCHAR(10),A.ICRA_TAR,103) AS 'İCRA TARİHİ', CONVERT(VARCHAR(10),A.HACIZ_TAR,103) AS 'HACİZ TARİHİ'
      FROM TAKIP A, YAZ..MARDATA.BIR_TAHSIL B, 
      YAZ..MARDATA.S_TEKLIF C,P_TAKIP_SR D, AVUKAT E
      WHERE B.TEKLIF_NO1 = C.TEKLIF_NO1
      AND B.TEKLIF_NO2 = C.TEKLIF_NO2
      AND A.T_HESAP_NO = C.HESAP_NO
      AND C.HESAP_NO = B.HESAP_NO
      AND B.HESAP_NO = E.HESAP
      AND A.T_SRM = D.T_SR_ID
      AND A.T_STATU = 2
      AND A.T_SRM &lt;&gt; 6
  </code></pre>
  
  <p>But when I run it, I get an error:</p>
  
  <blockquote>
    <p>Server Error in '/' Application.<br>
    Cannot resolve the collation conflict between "Turkish_CI_AS" and
    "SQL_Latin1_General_CP1_CI_AS" in the
    equal to operation.<br>
    Description: An unhandled exception occurred during the
    execution of the current web request.<br>
    Please review the stack trace for more
    information about the error and where
    it originated in the code.</p>
    
    <p>Exception Details: System.Data.SqlClient.SqlException:
    Cannot resolve the collation conflict
    between "Turkish_CI_AS" and
    "SQL_Latin1_General_CP1_CI_AS" in the
    equal to operation.</p>
    
    <p>Source Error:
        Line 77:     myConnection.Open();
        Line 78: 
        Line 79:     SqlDataReader dr = myCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
        Line 80: 
        Line 81:     // show the data</p>
  </blockquote>
  
  <p>I can't find the error. Where is it?</p>