SAP
C_HANAIMP_12 · Question #112
A company sends out a lot of quotes. Some customers accept the quotes, and they're invoiced. The company asks you to find a list of the customers that did NOT accept the quotes. How do you find the…
The correct answer is C. Use a left outer join. Filter to show only the NULL values on the right table. See the full explanation below for the reasoning.
Question
A company sends out a lot of quotes. Some customers accept the quotes, and they're invoiced. The company asks you to find a list of the customers that did NOT accept the quotes. How do you find the customers that received quotes but did NOT receive invoices? Please choose the correct answer. Response:
Options
- AUse a right outer join. Filter to show only the NULL values on the right table.
- BUse a left outer join. Filter to show only customers on the right table.
- CUse a left outer join. Filter to show only the NULL values on the right table.
- DUse a right outer join. Filter to show only customers on the left table.
How the community answered
(50 responses)- A2% (1)
- B8% (4)
- C74% (37)
- D16% (8)
Community Discussion
No community discussion yet for this question.