SAP
C_TAW12_740 · Question #62
You want to read data from two database tables A and B using a database join. Database table B contains details for data records stored in database table A. Your result should contain all…
The correct answer is D. SELECT ... FROM a LEFT OUTER JOIN b. See the full explanation below for the reasoning.
Question
You want to read data from two database tables A and B using a database join. Database table B contains details for data records stored in database table A. Your result should contain all combinations of matching rows from A and B plus all rows from A that do not have matching rows in B. Which statement do you use?
Options
- ASELECT ... FROM a JOIN b ...
- BSELECT ... FROM a INNER JOIN b ...
- CSELECT ... FROM b RIGHT OUTER JOIN a ...
- DSELECT ... FROM a LEFT OUTER JOIN b ...
How the community answered
(43 responses)- A5% (2)
- B9% (4)
- C16% (7)
- D70% (30)
Community Discussion
No community discussion yet for this question.