An analyst writes a query that joins an orders table with a customers table and wants to include all orders regardless of whether the customer record exists. Which JOIN type should they use?

Question

Accepted Answer

B. LEFT JOIN. A LEFT JOIN (LEFT OUTER JOIN) returns all rows from the left table (orders) and matching rows from the right table (customers). If no customer record exists for an order, NULL values are returned for the customer columns. An INNER JOIN would exclude orders without a matching customer. RIGHT JOIN would prioritize customers, excluding orders without customers. FULL OUTER JOIN would include both unmatched orders and unmatched customers.

An analyst writes a query that joins an orders table with a customers table and wants to include all orders regardless of whether the customer record exists. Which JOIN type should they use?

Related Questions

Discussion