title: How to JOIN two tables when not using any Primary Keys?
body: <p>I'm trying to <code>JOIN</code> 2 tables using columns that aren't either of the tables respective Primary Keys:</p>
  
  <pre><code>SELECT *
  FROM TableA A
  INNER JOIN TableB B
  ON A.col5 = B.col5
  </code></pre>
  
  <p>Yet the above is returning <code>0 results</code> even though I know for sure that there are rows in <code>Table A</code> whose <code>col5</code> values match values in <code>col5</code> of <code>Table B</code>.</p>
  
  <p>What am I doing wrong?</p>