Skip to main content

Right Anti Semi Join

Short Description

The right Anti Semi Join operator returns rows from the second input where it has no match in the first input.

Detailed Description

The right Anti Semi Join operator returns rows from the second input where it has no match in the first input. This can be used to check for orphaned child records using a NOT EXISTS type query.

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