title: How to deal with multiple lookup tables for beginners of SQL?
body: <p>I'm having a hard time wrapping my head around multiple lookup tables. I have a central table with all the info but IDs in each column:</p>
  
  <pre><code>db_supply (Main supplier information data table)
   -----------------------------------------------
  | Supplier_ID | Supply_Type_ID | Itm_ID | Stock |
  |-----------------------------------------------|
  | 1           | 1              | 33     | 3     |
  |-----------------------------------------------|
  | 2           | 2              | 28     | 1     |
   -----------------------------------------------
  
  lookup_supplier
   -----------------------------
  | Supplier_ID | Supplier_Name |
  |-----------------------------|
  | 1           | Walter        |
  |-----------------------------|
  | 2           | Jesse         |
   -----------------------------
  
  lookup_supply_type
   -----------------------------------
  | Supply_Type_ID | Supply_Type_Name |
  |-----------------------------------|
  | 1              | Import           |
  |-----------------------------------|
  | 2              | Delivery         |
   -----------------------------------
  
  lookup_itm
   ------------------------
  | Itm_ID | Itm_Name      |
  |------------------------|
  | 33     | Pickles       |
  |------------------------|
  | 28     | Burger        |
   ------------------------
  
  A query for 'Burger' will output this table:
   -----------------------------------------------------
  | Supplier_Name | Supply_Type_Name | Itm_Name | Stock |
  |-----------------------------------------------------|
  | Jesse         | Delivery         | Burger   | 1     |
   -----------------------------------------------------
  </code></pre>
  
  <p>How would I actually achieve this? So far I have:</p>
  
  <p><code>SELECT * FROM db_supply WHERE Itm_ID = (SELECT Itm_ID FROM lookup_itm WHERE Itm_Name = 'Burger')</code></p>
  
  <p>Which would give me the second row of the <code>db_supply</code> table with IDs not looked up yet. Do I have to nest my selects to look up multiple tables? No idea here.</p>