What is outer join in database?

By Arsal Ahmed   Posted on March-20-2018   540

FULL OUTER JOIN:

Another type of join is called a SQL Server FULL OUTER JOIN. This type of join returns all rows from the LEFT-hand table and RIGHT-hand table with nulls in place where the join condition is not met.

Syntax:

The syntax for the FULL OUTER JOIN in SQL Server (Transact-SQL) is:

SELECT columns
FROM table1
FULL [OUTER] JOIN table2
ON table1.column = table2.column;

By Arsal Ahmed    20-Mar-2018 Views  540



You may also read following recent articles