title: Joining tables using foreign key
body: <p>I have 2 tables , employees and departments.</p>
  
  <p>departments(id, department)</p>
  
  <p>employees(id, department_id, name, and a bunch more here)</p>
  
  <p>so employees.department_id is a foreign key to departments.id.</p>
  
  <p>I need to show the table employees, but instead of department_id (showing the IDs of the departments) I need to show the actual departments name, so in place of department_id, i need to place departments.department.</p>
  
  <p>How should I do this?</p>