INNER JOIN

SELECT e.name, d.name FROM employees e JOIN departments d ON e.dept_id = d.id;

LEFT JOIN

SELECT e.name, d.name FROM employees e LEFT JOIN departments d ON e.dept_id = d.id;