Table Joins

• SELECT department.id, department.dept, department.location, employee.id, employee.name, employee.title FROM department, employee WHERE department.dept = employee.dept;