Question 57 • Computer Applications - Office 2016 - EL3520 A
A left outer join keeps every row from the table on the left, even when there is no matching ID in the second table. In that case, the columns from the second table are returned as NULL. So the correct choice is left outer join.
AI-written and checked against the verified answer.