Question: Why will this query generate an error? SELECT employee _ id , salary FROM employees INNER JOIN salaries ON employee _ id = employee _

Why will this query generate an error?
SELECT employee_id, salary
FROM employees INNER JOIN salaries ON employee_id
= employee_id
WHERE salary >=75000;
Group of answer choices
The join predicate's 'employee_id'eld is ambiguous.
>= is not a valid operator.
No employees with a salary greater than or equal to 75000 exist in the database.
The above query will not return an error.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!