title: How to replace id's with values from another table
body: <p>I have the following query:</p>
  
  <pre><code>SELECT st.part_location_id_from, st.part_location_id_to, st.loginid
  FROM stock_transfer AS st, stock_transfer_confirmation AS stc
  WHERE st.id = stc.stock_transfer_id
  AND stc.confirmed = 0;
  </code></pre>
  
  <p>It retrieves all unconfirmed stock transfers. I would like to replace the id from <code>part_stock_location_id_from</code> and <code>part_stock_location_id_to</code> with the name of the location which I have in another table like:</p>
  
  <pre><code>    id descr
      1  Warehouse A
      2  Warehouse B
      2  Store A
  </code></pre>
  
  <p>etc.</p>
  
  <p>is there a way to get this in one query?</p>