title: Cannot resolve the collation conflict between "SQL_Latin1_General_Pref_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation
body: <p>I have the following query:</p>
  
  <pre><code>SELECT 
  DISTINCT(po.SONumber) AS [Sales Order No_],
   po.PONumber AS PoNo, ph.[Buy-from Vendor No_] AS VendorNo, 
   ph.[Pay-to Name], ph.[Document Date], 'Ship-to Name' = 
   CASE WHEN sh.[Ship-to Name] &gt; '' THEN sh.[Ship-to Name] ELSE sih.[Ship-to Name] END, 
   'Ship-to Post Code' = CASE WHEN sh.[Ship-to Post Code] &gt; '' THEN sh.[Ship-to Post Code] ELSE sih.[Ship-to Post Code] END, 
   sh.DeliveryPhoneNo AS [Delivery Phone No], 'CustomerPriceGroup' = CASE WHEN sh.[Customer Price Group] &gt; '' THEN sh.[Customer Price Group] ELSE sih.[Customer Price Group] END, 
   'DeliveryComment' = CASE WHEN sh.[Delivery Comment] &gt; '' THEN sh.[Delivery Comment] ELSE sih.[Delivery Comment] END, 
   'GiftMessage' = CASE WHEN sh.[GiftMessage] &gt; '' THEN sh.[GiftMessage] ELSE sih.[GiftMessage] END, 
   si.Shipped, si.ShippedDate, si.CourierID 
  
   FROM 
   NavisionMeta.dbo.PoToSo po, 
   [Crocus Live$Purchase Header] ph, 
   [Crocus Live$Purchase Line] pl, 
   [Crocus Live$Sales Header] sh, 
   [Crocus Live$Sales Invoice Header] sih, 
   NavisionMeta.dbo.SupplierInput si 
  
   WHERE po.PONumber = ph.[No_] AND 
   ph.[No_] = pl.[Document No_] AND 
   po.SONumber *= sh.No_ AND 
   po.SONumber *= sih.[Order No_] AND 
   po.PONumber *= si.PONo AND 
   ph.[Document Date] BETWEEN '01-01-10' AND '31-01-10' 
  
   ORDER BY po.PONumber DESC
  </code></pre>
  
  <p>When it executes, I get the following error:</p>
  
  <blockquote>
    <p>Cannot resolve the collation conflict
    between
    "SQL_Latin1_General_Pref_CP1_CI_AS"
    and "Latin1_General_CI_AS" in the
    equal to operation.</p>
  </blockquote>
  
  <p>The collation of the NavisionMeta database is SQL_Latin1_General_Pref_CP1_CI_AS</p>
  
  <p>What can I do to fix this??</p>