title: sql join int varchar
body: <p>I've been searching the questions but haven´t found an answer. I would like to do an inner join with Table 1 and Table 2 , but one field is INT and other is VARCHAR (with the structure "A-INT"). Something like:</p>
  
  <pre><code>    Table1                    Table2
  
      ID NAME   WHATEVER        ID USER
      1  A-001  ---             1  001 
      2  A-002  ---             2  002
      3  A-003  ---             3  003
      3  A-004  ---             4  004  
      ...
  </code></pre>
  
  <p>How can I construct the query? Something like:</p>
  
  <pre><code>... Table1 INNER JOIN Table2 ON Table1.NAME = Table2.[A-USER] ...
  </code></pre>