How_to_retrieve_data_from_two_or_more_tables_2/demo-queries-from slides-12.sql

SELECT departments.department_number, department_name, employee_id, 
    last_name
FROM departments CROSS JOIN employees
ORDER BY departments.department_number;

SELECT departments.department_number, department_name, employee_id, 
    last_name
FROM departments, employees
ORDER BY departments.department_number;