Implementing an Outer Join
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
LEFT and RIGHT OUTER JOIN is supported in natively compiled T-SQL modules starting SQL Server 2016 (13.x).
For more information about OUTER JOIN, see FROM clause plus JOIN, APPLY, PIVOT.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for