Explore Library
QuizAdvanced

INNER vs LEFT JOIN Behavior

Understand how INNER JOIN and LEFT JOIN differ when rows have no matching counterpart.

You have a `customers` table and an `orders` table. Some customers have never placed an order. Which query returns ALL customers, including those with no orders (showing NULLs for order columns)?