An inner join retains only records that match the join condition on both sides. It is appropriate when the question explicitly excludes orders without a known customer. The join key still matters: order ID and customer ID can overlap by accident in a small fixture. Test the joined population with unmatched keys and repeated purchases rather than relying on a plausible total.
Use the field picker and the generated result together. The warehouse contains repeated customer keys, orders with several items and missing values. Those rows make a plausible-looking total insufficient evidence. Run the requested definition, inspect its grain, and use the feedback to locate the mismatch. Every dataset here is fictional.
Restrict a report to orders with a known customer.