New: Cookbooks and AI ExplanationsStep-by-Step recipes to solve problems connected to Roadmaps and Cheat Sheets. Need more details? Use AI buttons for structured and simple explanations with concrete examples throughout the whole platform.Take a look
Customer details live in one table, order details in another, and the person asking does not care which table anything sits in, only that the final numbers match up.
What you'll have at the end
One query that lists every order next to its customer's name and email, with any order whose customer record is missing left visible instead of silently dropped.
You need
An orders table and a customers table sitting in the same database, with a column on the orders side that stores which customer placed each order.
Not covered
Why a customer record went missing from the customers table in the first place, or building an automated check that runs on every new order.
Checked 26 Aug 2026
Part of the SQL cookbook