Employees with department names
JoinsEasy
Return each employee's name and their department name as department, ordered by department then employee name.
Tables
departments: id, nameemployees: id, name, department_id, manager_id, salary, hired_on
Row order is checked. Column names do not have to match, but the number of columns and the values do.