Tag Archives: Anti Join

In SQL, an anti join is a type of JOIN that returns only the rows from one table that do not have matching rows in the other table. It is also sometimes referred to as an “excluding join” or “left anti join”. The opposite of an anti join is an …

In SQL, an anti join is a type of JOIN that returns only the rows from one table that do not have matching rows in the other table. This means that an anti join is useful when you want to find records that are present in one table but not …