---
title: "In-Memory OUTER JOIN | Microsoft Docs"
ms.custom: ""
ms.date: "06/01/2019"
ms.prod: sql
ms.prod_service: "database-engine, sql-database"
ms.reviewer: ""
ms.technology: in-memory-oltp
ms.topic: conceptual
ms.assetid: 67084043-6b23-4975-b9db-6e49923d4bab
author: MightyPen
ms.author: genemi
monikerRange: "=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current"
---
# Implementing an Outer Join

[!INCLUDE[appliesto-ss-asdb-xxxx-xxx-md](../../includes/appliesto-ss-asdb-xxxx-xxx-md.md)]

  LEFT and RIGHT OUTER JOIN is supported in natively compiled T-SQL modules starting [!INCLUDE[ssSQL15](../../includes/sssql15-md.md)].  
  
For more information about OUTER JOIN, see [FROM clause plus JOIN, APPLY, PIVOT](../../t-sql/queries/from-transact-sql.md).