Anti Join
A pattern that returns rows from one set that have no match in another.
Why it matters
Anti Join affects how data is matched, interpreted or acted on in real work. Understanding the term helps you choose the right tool and avoid silent assumptions in reports.
Practical check
When this concept appears in a spreadsheet, query or workflow, ask what one row represents, which values are allowed, and what should happen when data is missing or duplicated.