title: Inner join on ConCat fields
body: <h1>I have table A</h1>
  
  <pre><code>Code  Range
  A     12569 
  B     18175
  C     478931
  </code></pre>
  
  <h1>And Table B</h1>
  
  <pre><code>id      Type 
  A12569  0
  B18175  1
  C478931 0 
  </code></pre>
  
  <p>How can I concatenate the two fields of the first table, in order to join them with the second table.</p>
  
  <p>I have tried with the following  query</p>
  
  <pre><code>SELECT concat(A.code,B.Range),b.Type FROM DB.tableA A
  inner join DB.tableB B 
  on Concat(A.code,B.Range)= B.id;
  </code></pre>