SAP
C_TAW12_731 · Question #72
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
(63 responses)- A6% (4)
- B5% (3)
- C2% (1)
- D76% (48)
- E11% (7)
Community Discussion
No community discussion yet for this question.