title: JOIN ON with AND clause
body: <p>I'm having a hard time with a JOIN QUERY and it could be from my difficulty to grasp the JOIN syntax.</p>
  
  <pre><code>SELECT * FROM TABLE_A
  JOIN TABLE_B ON TABLE_B.Column1 = TABLE_A.Column1 
               AND (TABLE_B.Column1 + CONVERT(varchar(10), TABLE_B.Column2)) != TABLE_A.Column1
  </code></pre>
  
  <p>I need to obtain rows from both table where both those conditions are met but currently the returned results are as if the AND condition wasn't even present...</p>
  
  <p>Any idea on the achieve this? To help put in context:</p>
  
  <pre><code>Table A         Table B
  ABCD            ABCD        21          Username1
  ABCD21          ABCD        10          Username2
  ABCD                        
  ABCD            
  ABCD21
  ABCD21
  </code></pre>
  
  <p>Desired output:</p>
  
  <pre><code>Table C
  ABCD        10      Username1
  ABCD        10      Username1
  ABCD        10      Username1
  </code></pre>
  
  <p>P.S. I currently can do the opposite of my question which is:</p>
  
  <pre><code>SELECT * FROM TABLE_A
  JOIN TABLE_B ON (TABLE_B.Column1 + CONVERT(varchar(10), TABLE_B.Column2)) = TABLE_A.Column1
  </code></pre>