Using Outer Joins

All rows from both tables are returned in a full outer join. SQL Server uses the following ISO keywords ...

technet.microsoft.com