Right Semi Join

Optimizing SQL Database Performance

Optimizing Database Performance

Right Semi Join

The Right Semi Join logical operator returns each row from the second (bottom) input when there is a matching row in the first (top) input. If no join predicate exists in the Argument column, each row is a matching row.

See Also

Using Joins