title: Error converting data type varchar to numeric on join clause
body: <p>Please help with this query.  I am getting an</p>
  
  <blockquote>
    <p>error converting data type varchar to numeric" on my join clause.</p>
  </blockquote>
  
  <pre><code>select 
         MARKETING
         ,HOME_TEL
         ,BUS_TEL 
         ,CEL_TEL 
         ,EMAIL   
         ,FAX 
         ,VALID_MAIL
         ,VALID_PHONE 
         ,VALID_SMS   
         ,VALID_EMAIL
         into [storagedb - baw].dbo.Geyser_Glynis
      from [storagedb - Mariana].dbo.HOC_Geyser_v2 as a
         left join [IIIDB].[dbo].[EEE_BASE_201901] as b
                on a.gcustomer_Number= b.Dedupe_Static
  </code></pre>