Question

what is wrong with this database says inner is not a table

SELECT last_name, first_name, job_title, salary, min_salary, max_salary,
city, state_province, country_name
FROM employees INNER JOIN jobs ON employees.job_id = jobs.job_id,
INNER JOIN departments dep ON employees.department_id = dep.department_id
INNER JOIN locations ON dep.locations_id = locations.location_id
INNER JOIN countries ON locations.country_id = countries.country_id
WHERE dep.location_id = 1700
ORDER BY salary DESC;

Answer 1

Dear Student ,

As per requirement submitted above kindly find below solution.

Error details :

• There is comma (,) at the end of the first inner join that is at the end of the line three remove that comma

Below is the corrected SQL query.

SELECT last_name, first_name, job_title, salary, min_salary, max_salary,
city, state_province, country_name
FROM employees INNER JOIN jobs ON employees.job_id = jobs.job_id
INNER JOIN departments dep ON employees.department_id = dep.department_id
INNER JOIN locations ON dep.locations_id = locations.location_id
INNER JOIN countries ON locations.country_id = countries.country_id
WHERE dep.location_id = 1700
ORDER BY salary DESC;

NOTE :PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.