title: Postgres Join with LIKE
body: <p>In PostgreSQL I have a table </p>
  
  <pre><code>tbl1
  id -- RCODE -- COUNTRY --
  1     US/MSR   United states of America
  2     GY/LSR   Germany
  3     CA/FSA   Canada
  
  tbl2
  id -- Name -- CCODE
  33    T1      US        
  44    Y1      CA       
  55    W1      GY  
  </code></pre>
  
  <p><strong>can the tables be joined with LIKE condition on fields  RCODE on tbl1 with  CCODE on tbl2 ?</strong>  such that
  i gets  the result as </p>
  
  <pre><code>id --NAME-- RCODE -- CCODE--- COUNTRY
  </code></pre>
  
  <p>i shall provide the id of tbl2 ie) when i give the id 44
  the result will be </p>
  
  <pre><code>id --NAME-- RCODE -- CCODE--- COUNTRY
  44   Y1     CA/FSA   CA       Canada
  </code></pre>
  
  <p>can any one help me to solve this query , it is PostgreSQL</p>
  
  <p><em><strong>one thing is that  first two char in RCODE is same to that of CCODE in table2.</em></strong></p>