Execute the following SQL Server T-SQL script in Management Studio Query Editor to demonstrate the use of Full Outer Join which returns no matches from both tables in addition to matches:

-- SQL full join - SQL inner join - SQL full outer join

USE AdventureWorks;

GO

SELECT   C.Name  AS Category,

         SC.Name AS Subcategory,

         PM.Name AS Model,

         P.Name  AS Product,

         P.ListPrice

FROM     Production.Product AS P

         FULL JOIN Production.ProductModel AS PM

           ON PM.ProductModelID = P.ProductModelID

         FULL JOIN Production.ProductSubcategory AS SC

           ON SC.ProductSubcategoryID = P.ProductSubcategoryID

         INNER JOIN Production.ProductCategory AS C

           ON C.ProductCategoryID = SC.ProductCategoryID

ORDER BY Category,

         Subcategory;

GO

Partial results:

Relates article:

Better Alternatives to a FULL OUTER JOIN