There are two tables: Professor and Department. In order to retrieve all employees and their department names, even if some employees are not assigned to a department, which JOIN should be used?
-
A.
FULL JOIN
-
B.
INNER JOIN
-
C.
LEFT JOIN
-
D.
RIGHT JOIN
Correct Answer:
C. LEFT JOIN
Explanation:
To retrieve all records from an employee table along with their corresponding department information, including those employees who have not been assigned to a specific department, a LEFT JOIN is the correct choice. This type of join ensures that every row from the primary (left) table is included in the results; if there is no matching record in the secondary (right) table, the result set will simply contain null values for the department columns. This approach prioritizes the preservation of all employee data regardless of their assignment status.
Click below to open Discussion & Feedback
0 Issues
Please
login to comment or Report Issues.