Skip to main content

Left Anti Semi Join

Short Description

The Left Anti Semi Join returns rows from the first input that have no match in the second input

Detailed Description

The Left Anti Semi Join returns rows from the first input that have no match in the second input. This construct can be seen as a result of a NOT EXISTS type subquery.

Search online

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.

DBmarlin Trial