QuestionQ13

VerifiedDatabase Fundamentals

A business analyst uses a client table and an invoice table to build a database view that displays clients who have not yet made purchases. Which join is most appropriate for creating this database view?

Explanation

A left outer join preserves every client row and joins matching invoice rows when they exist. Filtering for a NULL invoice key identifies clients for whom no corresponding invoice exists, which represents clients with no purchases.

Community Discussion

No comments yet. Be the first to start the discussion!