JOIN ON with AND clause
<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>