United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2000

Microsoft SQL Server 2000

SQL Server 2000 Books Online

Optimizing Database Performance

Query Tuning

Analyzing a Query

Logical and Physical Operators

Assert

Aggregate

Bookmark Lookup

Clustered Index Delete

Clustered Index Insert

Clustered Index Update

Clustered Index Scan

Clustered Index Seek

Collapse

Concatenation

Constant Scan

Cross Join

Delete

Deleted Scan

Distinct

Distinct Sort

Distribute Streams

Eager Spool

Filter

Flow Distinct

Full Outer Join

Hash Match

Hash Match Root

Hash Match Team

Index Delete

Index Insert

Index Scan

Index Seek

Index Spool

Index Update

Inner Join

Insert

Inserted Scan

Lazy Spool

Left Anti Semi Join

Left Outer Join

Log Row Scan

Merge Join

Nested Loops

Parallelism

Parameter Table Scan

Remote Delete

Remote Insert

Remote Query

Remote Scan

Remote Update

Repartition Streams

Right Anti Semi Join

Right Outer Join

Right Semi Join

Row Count Spool

Sequence

Sort

Split

Stream Aggregate

Table Delete

Table Insert

Table Scan

Table Spool

Table Update

Top

Union

Update

Cursor Logical and Physical Operators

Minimize

0 out of 2 rated this helpful - Rate this topic

Left Semi Join

SQL Server 2000

Left Semi Join

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

See Also

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

© 2013 Microsoft. All rights reserved.