Exam C-THR92-2505 Topic 6 Question 58 Discussion
Actual exam question for SAP's C-THR92-2505 exam
Question #: 58
Topic #: 6
Question #: 58
Topic #: 6
You want to join two tables, A and B, and you want to include all rows from Table A, and only matching rows from Table B. Which join type must you use?
Suggested Answer: B Vote an answer
* 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 in NULL where 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 RequirementA Left Join is the appropriate choice to include all rows from Table A and only matching rows 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
* Types of Joins
* Outer Join: Includes all rows from both tables, filling in NULL where 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 RequirementA Left Join is the appropriate choice to include all rows from Table A and only matching rows 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
by Justin at Oct 21, 2025, 05:43 AM
0
0
0
10
Comments
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Report Comment
Commenting
You can sign-up / login (it's free).