How to replace id's with values from another table
<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>