title: Inner Join results in no records returned even when join criteria exist in both tables
body: <p>I am trying to perform an Inner Join on two tables and no records are being returned. Both tables are being joined on Postal Code, which is stored as a VARCHAR(50).</p>
  
  <pre><code>    SELECT 
          T1.Name
         ,T1.PostalCode
         ,T2.Address
      FROM FirstTable as T1
          INNER JOIN SecondTable as T2 ON T1.PostalCode = T2.PostalCode
  </code></pre>
  
  <p>The result is no records are returned. I tried trimming white space from the Postal Code field in both tables and still have no results.</p>
  
  <p>I then tried to narrow down the issue by using a separate select statement. The select statement below returns the record with the Postal Code and Address:</p>
  
  <pre><code>    SELECT PostalCode, Address, FROM SecondTable WHERE PostalCode = 'A1A1A1'
  </code></pre>
  
  <p>When I try this query on the first table, no records are returned:</p>
  
  <pre><code>    SELECT Name, PostalCode FROM FirstTable WHERE PostalCode = 'A1A1A1'
  </code></pre>
  
  <p>This is very perplexing because manually viewing the table in Excel reveals a record exists for the postal code.</p>
  
  <p>Does anyone have any thoughts?</p>