SQL Server provides the full outer join operator, FULL OUTER JOIN, which includes all rows from both tables, regardless of whether or not the other table has a matching value.

• SQL Server提供了完全外部联接运算符FULL OUTER JOIN,它将包括两个表中的所有行,不论另一个表中是否有匹配的值。