CODE EXAMPLE FOR SQL

displaying different entities from different tables at once

SELECT E.first_name NAME,D.department_name DNAME
FROM employees E JOIN departments D
ON (E.department_id = D.department_id);