注意，所执行的联接是个外部联接。
使用谓词可以进一步限定外部联接。
An outer join can be further restricted by using a predicate.
列出关于使用联接查询多个表的主题，例如如何创建外部联接和如何自动联接表。
Lists topics on using joins to query multiple tables, such as how to create outer joins and how to join tables automatically.
“联接”对话框中设置选项，可以基于不同运算符指定联接，并且可以指定外部联接。
Join dialog box, you can specify a join based on a different operator, and you can specify an outer join.
merge语句首先进行(外部联接或者内部联接，取决于merge语句)源与目标表行之间的联接。
The merge statement first does a join (outer join or inner join, depending on the merge statement) between source and target table rows.
左外部联接是这样一个联接：在其中返回第一个集合的每个元素，而无论该元素在第二个集合中是否具有相关元素。
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.
当选择创建外部联接的选项时，联接线中的菱形图会改变，以指示联接是左外部联接、右外部联接还是完全外部联接。
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.
如果您想要使用触发器、聚合函数、外部联接、视图以及其他SQL功能，HSQLB都可以满足您的需要(大部分轻量级关系数据库无法做到这一点)。
If you want triggers, aggregated functions, outer joins, views, and other SQL features, they are all there (something you won't get from most lightweight relational databases).
通常情况下，在外部输入的基数显然不小且对于内部表没有一种有效的访问方法时，优化器会选择合并扫描联接。
Typically, the optimizer chooses merge scan join when the cardinality of the outer input is not obviously small and there is no efficient access method for the inner table.
在图7 上图6与图 7之间所不同的是，一个SORT节点被添加到联接的外部。
The difference between Figure 6 and Figure 7 is that in Figure 7, a SORT node is added on the outer side of the join.
与本文中的其他不同数据源场景一样，将外部数据联接到现有包将在IBMCognosBI服务器上导致某种形式的本地处理。
As with other disparate data source scenarios in this document, joining external data to your existing package will incur some form of local processing on the IBM Cognos BI servers.
请注意在图7中联接的外部Fetch节点上所显示的基数之间有一个显著的不同。
Notice that there is a significant difference between the cardinality shown in the fetch node on the outer side of the join in Figure 7.
因为嵌套循环联接的工作方式，所以每隔一个外部表记录执行第二步(共4个节点)。
Because of how nested loop joins work, the second leg (there are four nodes) is executed per outer table record.
也就是说，联接操作的内部表将被扫描8次，来自外部输入的 8 个合格的记录每个都将被扫描一次。
That is, the inner table of the join operation will be scanned eight times, once for each of the eight qualifying records from the outer input.
使用内部和外部排序的合并扫描联接 (MSJOIN)
因此，也要添加sort节点到联接的外部来执行顺序。
Therefore, a SORT node is also added to the outer of the join to enforce the order.
斜接长度是指线壁在联接内部的交点与线壁在联接外部的交点之间的距离。
The miter length is the distance from the intersection of the line walls on the inside of the join to the intersection of the line walls outside of the join.
斜接长度是指线壁在联接内部的交点与线壁在联接外部的交点之间的距离。
The miter length is the distance from the intersection of the line walls on the inside of the join to the intersection of the line walls outside of the join.
应用推荐