Implementing an Outer Join

SQL Server 2016 and later
 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2014)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

LEFT and RIGHT OUTER JOIN is supported in natively compiled T-SQL modules starting SQL Server 2016.

Community Additions

ADD
Show: