SAP
C_TAW12_71 · Question #412
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 b RIGHT OUTER JOIN a. 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
Options
- AWhich statement do you use?
- BSELECT ... FROM a JOIN b ...
- CSELECT ... FROM a INNER JOIN b ...
- DSELECT ... FROM b RIGHT OUTER JOIN a ...
- ESELECT ... FROM a LEFT OUTER JOIN b ...
How the community answered
(61 responses)- A3% (2)
- B2% (1)
- C11% (7)
- D80% (49)
- E3% (2)
Community Discussion
No community discussion yet for this question.