Question: 2 You are performing an INNER JOIN on two tables on the employee_id column. The left table is employees, and the right table is machines.
2 You are performing an INNER JOIN on two tables on the employee_id column. The left table is employees, and the right table is machines. Which of the following queries has the correct INNER JOIN syntax? 1 point SELECT * FROM employees INNER JOIN machines WHERE employees.employee_id = machines.employee_id; SELECT * FROM employees INNER JOIN ON employees.employee_id = machines.employee_id; INNER JOIN machines ON employees.employee_id = machines.employee_id SELECT * FROM employees; SELECT * FROM employees INNER JOIN machines ON employees.employee_id = machines.employee_id
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
