Implementing an Outer Join

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.