Exam TDA-C01 topic 1 question 90 discussion

You have two tables named EmployeeInfo and DepartmentInfo. EmployeeInfo contains four fields named Full Name, Department ID, Start Date, and Salary. DepartmenIinfo contains four fields named Department Name, Size, Department ID, and VP.

You want to combine the tables to meet the following requirements:

• Each record in EmployeeInfo must be retained in the combined table.
• The records must contain the Department Name, Size, and VP fields.
• Every record must have a full name.

Which type of join should you use?