Glossary: SQL Beyond the Basics
Anti-join
Also written: anti join
A pattern that finds rows with no match in another table. It uses a LEFT JOIN and keeps only the rows where the right side is NULL, or uses NOT EXISTS.
Glossary: SQL Beyond the Basics
Also written: anti join
A pattern that finds rows with no match in another table. It uses a LEFT JOIN and keeps only the rows where the right side is NULL, or uses NOT EXISTS.