Note that the join being performed is an outer join.
注意，所执行的联接是个外部联接。
You join two tables by using an inner join or an outer join.
可以通过使用内连接或外连接来连接两个表。
In this regard, the query is similar to a left outer join in SQL.
从这种意义上说，查询与 SQL中的左外连接相似。
In these cases, keep in mind that the local processing of a full outer join may also impact performance.
这种情况下，请记住，完全外连接的本地化处理也会影响性能。
Figure 8 shows that the left outer join operations are cascaded if a rule USES more than one reference column.
图8展示了如果规则使用了多个参考列，那么左外部连接就进行级联。
An outer join can be further restricted by using a predicate.
使用谓词可以进一步限定外部联接。
The merge statement first does a join (outer join or inner join, depending on the merge statement) between source and target table rows.
merge语句首先进行(外部联接或者内部联接，取决于merge语句)源与目标表行之间的联接。
A left outer join is a join in which each element of the first collection is returned, regardless of whether it has any correlated elements in the second collection.
左外部联接是这样一个联接：在其中返回第一个集合的每个元素，而无论该元素在第二个集合中是否具有相关元素。
For example, using SQL to create a multi-table outer join that outputs its results to a new XML document is much more complicated to the average developer than writing XQuery.
比方说，对于一般开发人员，使用SQL创建输出结果为新xml文档的多表外连接查询要比编写XQuery复杂得多。
When you select an option to create an outer join, the diamond graphic in the join line changes to indicate that the join is a left outer, right outer, or full outer join.
当选择创建外部联接的选项时，联接线中的菱形图会改变，以指示联接是左外部联接、右外部联接还是完全外部联接。
The fact that this is also called an INNER JOIN might also indicate that an alternative called OUTER JOIN exists.
这也被称为INNERJOIN，这一事实也表明有另一种称作OUTER JOIN的类型存在。
(+) join syntax this syntax is actually discouraged even by Oracle, but there are numerous applications and developers who still use this form of OUTER join syntax.
(+)连接语法这种语法实际上甚至连Oracle都不提倡了，但是有很多应用程序和开发人员仍在使用这种形式的OUTER join语法。
(+) join syntax this syntax is actually discouraged even by Oracle, but there are numerous applications and developers who still use this form of OUTER join syntax.
(+)连接语法这种语法实际上甚至连Oracle都不提倡了，但是有很多应用程序和开发人员仍在使用这种形式的OUTER join语法。
应用推荐