You want to join two tables, A and B, and you want to include all...

Understanding JoinsIn reporting or database queries, a join determines how two tables are combined based on a related column.

Types of Joins

Outer Join: Includes all rows from both tables, filling inNULLwhere no match exists.

Left Join: Includes all rows from the left table (Table A) and only matching rows from the right table (Table B).

Inner Join: Includes only rows that have matches in both tables.

Correct Join for the RequirementALeft Joinis the appropriate choice to include all rows from Table A and only matchingrows from Table B. This ensures Table A's data remains intact while incorporating relevant data from Table B.

References

SAP SuccessFactors Reporting Joins: User Guide