title: In MySQL how do I use my table reference twice for a single select?
body: <p><strong>Example:</strong> </p>
  
  <pre><code>Table: Unit
  ID NAME  VALUE
  1  Kilo  1000
  2  Mega  1000000
  3  Giga  1000000000
  
  Table: Storage
  ID Title    Drive_value Drive_unit_ID Cache_value Cache_unit_ID 
  1  Seagate  100         3             400         1 
  2  Scansoft 250         3             80          2 
  </code></pre>
  
  <p><strong>Relations:</strong>  </p>
  
  <pre><code>Storage.Cache_unit_ID references Unit.ID
  Storage.Drive_unit_ID references Unit.ID 
  </code></pre>
  
  <p><strong>Desired Goal:</strong>
  To do a select * from Storage, display new columns 'AS' Drive and 'AS' Cache and display this by multiplying appropriate Unit.VALUE</p>
  
  <pre><code> Title     Drive          Cache  
   Seagate   100000000000   400000          
   Scansoft  250000000000   80000000000          
  </code></pre>