Question

BONUS QUESTION:

Suppose you have two tables, EMPLOYEES with primary key employee_ID, and DEPARTMENTS with primary key department_ID. Assume each department may have many employees, but each employee is only assigned one department.

What would be the correct SQL syntax for retrieving data from both tables?

(HINT: You must find out what is the foreign key)

		A. SELECT employee_ID, employee_name, department_ID, department_location FROM Employees JOIN Departments ON Employees.employee_ID = Departments.employee_ID;
		B. SELECT employee_ID, employee_name, department_ID, department_location FROM Employees JOIN Departments ON Departments.employee_ID = Employees.employee_ID;
		C. SELECT employee_ID, employee_name, department_ID, department_location FROM Employees JOIN Departments ON Employees.department_ID = Departments.department_ID;
		D. SELECT employee_ID, employee_name, department_ID, department_location FROM Employees JOIN Departments ON Employees.employee_ID = Departments.department_ID;

Answer 1

Answer:-

C.

SELECT employee_ID, employee_name, department_ID, department_location

FROM Employees JOIN Departments ON Employees.department_ID = Departments.department_ID;