Implementing an Outer Join

THIS TOPIC APPLIES TO: yesSQL ServeryesAzure 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.