title: SQL Query Concatenate two columns during Inner JOIN
body: <p>I have table A and table B with Table A having several columns including A1 and A2. Table B too has several columns.
  My query requires me to concatenate the values in A1 and A2 and then do an inner join on B1.</p>
  
  <p>Example:</p>
  
  <pre><code>Select * 
  From A
  INNER JOIN B
  ON CONCAT(A1,A2) = B1.
  </code></pre>
  
  <p>Apparently this is not how it should work. Can someone please give me a hand in this query?</p>
  
  <p>Thanks.</p>