Which SELECT statement is an equijoin query between two tables?
-
SELECT location.location_name, employee.salary FROM location, employee WHERE location.id = employee.location_no;
-
SELECT location.location_name, employee.salary FROM location, employee WHERE employee.salary BETWEEN location.avg_salary AND location.max_salary;
-
SELECT location.location_name, employee info.last_name FROM employee location, employee employee info WHERE employee info.id >= location.manager_id;
-
SELECT location.location_name, employee.salary FROM location, employee WHERE location.id = employee.region_no(+);
An equijoin is a join based on equality between columns from two tables. Option A shows the classic equijoin syntax using a WHERE clause with the equality operator (=) to match location.id with employee.location_no. Option B uses a BETWEEN range condition, not equality. Option C uses >= which is a non-equal comparison. Option D uses the outer join operator (+), which creates an outer join, not an equijoin.