title: Dividing and multiplying columns in mySQL
body: <p>This has been bugging me for some time i have following two tables:</p>
  
  <pre><code>Table: conv
  ---------------
  id       cur     toEUR
  --------------------------------------------
  1       EUR       1
  2       GBP       0.85
  3       USD       1.32
  --------------------------------------------
  
  Table: itms
  --------------
  id       cur       price
  --------------------------------------------
  1       USD       5
  2       USD      10
  3       EUR       2.5
  ---------------------------------------------
  </code></pre>
  
  <p>Basically I need to divide the appropriate values... </p>
  
  <pre><code>SELECT itms.price/conv.toEUR 
    FROM itms
       , conv 
   where itms.cur=conv.cur
  </code></pre>
  
  <p>...from 'itms' with the ones from 'conv' and multiply by the value I want to convert to in 'conv'.<br> Is this possible purely in SQL? I have attempted a few times, but I'm not sure what the best approach is.. <br> Any hints are appreciated!<br><br> Best Regards</p>