Home

Outer Joins

Introduction

An outer join is an operation that creates a list of records of two (or more) entities as follows:

Letís consider the following list of departments of a company:

Departments Table

Departments Table

Letís consider the following list of employees of a company:

Employees Table

 

Employees Table

The outer join operation is performed using the OUTER JOIN operator. It comes in various options, which precede the OUTER JOIN expression with a certain keyword:


Home Copyright © 2011-2019, FunctionX, Inc. Home