This one’s classic SQL logic, so B is right. Left join grabs everything from table A and only pulls in matching records from table B. If there’s no match on B, you still see the row from A with nulls for B’s columns. I’m pretty sure that fits what the question asks for, but open to correction if anyone sees it different.
Q: 15
You want to join two tables, A and B, and you want to include all rows from Table A, and only
matching rows from Table B. Which join type must you use?
Options
Discussion
B. Super clear wording on this one, matches the join behavior exactly from other SAP and SQL practice sets I've seen.
Option B
I don’t think it’s C. B is correct since left join always brings all rows from Table A, not just the ones that match in B. Easy to mix up with inner join here since the wording is tricky.
Makes sense to pick B. With a left join, you keep every row from Table A and pull in rows from B only where there’s a match. Pretty sure that’s the right call, but someone let me know if I’m missing anything.
Don't think it's C, since that'd only show matches from both tables and skip any A-only rows. B makes sense because left join keeps everything from Table A, even if no match in B. Seen similar in other SAP practice sets.
B imo, inner is a trap since it skips non-matching A rows.
Probably B
B tbh. That's how you get all rows from A and only the matching ones from B, so fits the scenario.
Option B for sure, always use left when you want all from A and matched from B.
Be respectful. No spam.
Question 15 of 15