Inner Join Question
I am looking at a sample question for the ABAP certification exam. Either I am reading the question incorrectly, or I missed an important concept. I'd appreciate someone to check me here:
What happens when a 1 to many relationship is encountered with an inner join? A. Redundant data from the right-hand table is included. B. Redundant data from either table is not returned to the result set. C. Redundant data from the left-hand table is included. D. Runtime error.
I chose C, but the answer key says B. Did I miss an important concept, or is the answer key wrong?