SQL Server - Physical Joins Operators

We use logical operators when we write queries to define a relational query at the conceptual level (what needs to be done). SQL implements these logical operators with different physical operators to implement the operation defined by the logical operators (how it needs to be done). Although there are dozens of physical operators but for logical joins it uses three physical join operators. Although we have different kinds of logical joins at the conceptual/query level, but SQL Server implements them all with three different physical join operators, click here for details.