title: SQL - EXCEPTION TO A JOIN STATEMENT
body: <p>I have two tables I would like to join. One has currency references and the other has the names for the currency references. It is like a regular inner join exercise with one exception. The currency reference of 0 in the first table is actually 160 in the other. How can I manipulate my join statement to overcome this problem?</p>
  
  <p>TABLE 1</p>
  
  <blockquote>
  <pre><code>       CREDIT TYPE               TRCURR
            CAR LOAN                    0
       CONSUMER LOAN                    0
            CAR LOAN                   20
            CAR LOAN                    1
  </code></pre>
  </blockquote>
  
  <p>TABLE 2</p>
  
  <blockquote>
  <pre><code>  CURRENCYREF     NAME_
              1       EUR
             20       YEN
            160       USD
  </code></pre>
  </blockquote>
  
  <p>Note that all <code>TRCURR</code> - <code>CURRENCYREF</code> combinations are correct except for the fact that the currency <code>160</code> is <code>0</code> in TABLE 1.</p>
  
  <p>THANKS! </p>