Left Outer Join
Short Description
The Left Outer Join operator returns all rows from input 1 along with rows from input 2 that match the join condition
Detailed Description​
The Left Outer Join operator returns all rows from input 1 along with rows from input 2 that match the join condition. Non matching rows have the input 2 vales set to NULL.
Additional Links​
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
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.