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中的左外连接相似。
An outer join can be further restricted by using a predicate.
使用谓词可以进一步限定外部联接。
There is also a full outer join between these two sub queries based on a column called sc.
在基于名为sc 的列上还有两个子查询的完全外连接。
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展示了如果规则使用了多个参考列,那么左外部连接就进行级联。
For a nullable joined column, is it better performance to do a outer join, or inner join to a "null" row?
一个空连接柱,它是更好的性能做了一个外连接,或内加入一个“空”行吗?
Join dialog box, you can specify a join based on a different operator, and you can specify an outer join.
“联接”对话框中设置选项,可以基于不同运算符指定联接,并且可以指定外部联接。
This query performs an outer join to compare the sales information for 10 particular stores for January and November.
这个查询会执行一个外连接操作,以便比较从 1 月份至 11 月份的10 个特殊商店的销售信息。
The fact that this is also called an INNER JOIN might also indicate that an alternative called OUTER JOIN exists.
这也被称为INNERJOIN,这一事实也表明有另一种称作OUTER JOIN的类型存在。
Lists topics on using joins to query multiple tables, such as how to create outer joins and how to join tables automatically.
列出关于使用联接查询多个表的主题,例如如何创建外部联接和如何自动联接表。
A full outer join in which all rows from both tables will be included, even if they do not have matches in the related table.
外部联结,将包括左边资料表的所有资料列,即使该资料列在相关资料表并没有相符项目。
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语句)源与目标表行之间的联接。
Outer join in which all rows from the table represented on the left will be included, even if they do not have matches in the related table.
外部联结,将包括右边资料表的所有资料列,即使该资料列在相关资料表中并没有相符项目。
Outer join in which all rows from the table represented on the right will be included, even if they do not have matches in the related table.
完整的外部联结,将同时包括两边的资料表,即使该资料列在相关资料表中并没有相符项目。
The combined record is much easier to use-you only have to check the PICTURE field to see if it's not null (which was the result of the LEFT OUTER JOIN).
而组合的记录使用起来要容易得多—只需检查PICTURE字段,查看它是否为空(这是LEFTOUTER JOIN的结果)。
The following illustration shows a conceptual view of two sets and the elements within those sets that are included in either an inner join or a left 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语法。
In SQL terms, this merge calls for an outer join, which matches each row in the work items data set to the single row in the states data set with a matching state ID.
在sql术语中,该合并会调用一个外层联系,它会将工作项数据集合中的每一行,与状态数据集合中的单个行使用匹配状态ID来匹配起来。
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 number of rows retrieved from the outer table after the database server applies any table filters is small, and the inner table has an index that can be used to perform the join.
在数据库服务器使用所有表筛选器之后,从外部表检索出的行数将很少,而内部表具有一个可用于执行连接的索引。
Having mentioned possible collisions between the outer and the inner legs of a join, it should also be mentioned that a similar problem could occur between the function and the INSERT operation.
提到连接的内表和外表之间各种可能的冲突之后,还应该提到的是,在这个函数与INSERT操作之间也可能发生类似的问题。
I invite all such to join themselves, as true sons of knowledge, with me, that passing by the outer courts of nature, which Numbers have trodden, we may find a way at length into her inner Chambers.
我邀请所有这样的人加入他们,身为知识的真正的儿子,跟我一起,数着脚下的路,穿过自然的层层樊篱,也许我们最终能发现内在的规律。
Join operators such as HASH, MERGE SCAN and (in some situations) NESTED LOOP can also benefit from asynchrony by simultaneously executing the inner and outer legs of the join operator.
MERGESCAN等连接操作符和(在某些情况下)NESTEDLOOP也可以通过同时执行连接操作符的内分支和外分支而从异步中获益。
TBSCAN (7) as the outer of the join provides the list of items to the function.
TBSCAN(7)是该连接的外表,它为函数提供产品列表。
Therefore, a SORT node is also added to the outer of the join to enforce the order.
因此,也要添加sort节点到联接的外部来执行顺序。
IT then reads from the outer table BAD_CREDIT using the SHIP operator, hashing the join column values, and checking in the lookup table generated for the inner table.
然后,它使用SHIP操作符读外表BAD_CREDIT,散列连接列的值,并检查为内表生成的查找表。
应用推荐