title: Multiply 2 values from 2 different tables
body: <p>I'm trying to multiply value X by value Y with SQL. Value X is located in table A and B is located in table B. I couldn't find the answer for this.</p>
  
  <p><strong>Table Transactions</strong></p>
  
  <pre><code>ID Transaction_ID Total_Amount
  1  001            1200
  2  002            1500
  3  003            1600
  </code></pre>
  
  <p><strong>Table Rates</strong></p>
  
  <pre><code>ID Currency_Name Exchange_Rate
  1  AUD           1.5
  2  SEK           2.0
  3  PLN           3.0
  </code></pre>
  
  <p>The question I'm trying to answer is:</p>
  
  <p>What is the Total_Amount for transaction 001 in SEK (Swedish Crown). So I need to multiply 1200 * 2.0 and display the result.</p>