A silver job joins customers (left) to orders (right) on customer_id. The output must list every customer, with the order columns set to NULL for customers who have not ordered yet. Which join type meets this?
Choose an answer to check it. Afterward, select any option to review its explanation.
A semi join sounds close because it is driven by the left table, but it returns only left rows that do have a match and no columns from the right side.
An inner join keeps only customers that have a matching order, so customers without orders would disappear.
A cross join pairs every customer with every order, ignoring customer_id entirely.
A left outer join keeps every row of the left table and fills the right-side columns with NULL when no order matches.
id qdf91fe3ae5