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

What will this return for departments with no employees?

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

What does RIGHT JOIN do?

How do you simulate FULL OUTER JOIN in MySQL?

SELECT d.dept_name FROM departments d LEFT JOIN employees e ON d.dept_id = e.dept_id WHERE e.emp_id IS NULL;

What does this find?

SELECT e.name, d.dept_name FROM employees e JOIN departments d USING (dept_id);

When can USING be used?