A Data Analyst has two tables named EmployeeInfo and DepartmentInfo.

A Data Analyst has two tables named EmployeeInfo and DepartmentInfo. EmployeeInfo contains four fields named Full Name, Department ID, Start Date, and Salary. DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP. The analyst wants to combine the tables to meet the following requirements:

EmployeeInfo is the first table that is dragged to the canvas,

The records must contain the Full Name, and the Department Name, Size, and VP fields if available,

Not all records have an exact match.

Which type of join should the analyst use?