Data engineering and IT

Anti-join

  • Data engineering and IT

Definition

Finding rows in one table that have no match in another, such as customers who have never ordered.

For your role

Choose your role to see what this term means in your work.

Why it matters

Where it is used

Gap analysis, data quality checks and finding what is missing.