inner join

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语句）源与目标表行之间的联接。

an inner join is essentially the intersection of two tables, where the tables are matched by comparing the values of a key column, such as itemnumber.

内连接实际上是两个表的交集，它通过比较关键列（比如itemNumber）的值来匹配表。

after a join hint is specified, the inner keyword is no longer optional and must be explicitly stated for an inner join to be performed.

指定联接提示后，要执行INNERJOIN时，INNER关键字不再为可选，而必须显式说明。

since this is an inner join, this view has no rows for records that appear in wells but not in wells_pts ( because they have null or invalid coordinates).

因为这是一个内联结，所以这个视图不包含出现在wells表中但没有出现在wells pts表中的记录（因为这些记录具有空的或无效的坐标）。

What you see here is a join in which the inner performs database modifications.

这里您看到的是一个连接，内表在其中执行数据库修改。

the fact that this is also called an inner join might also indicate that an alternative called outer join exists.

这也被称为INNERJOIN，这一事实也表明有另一种称作OUTERJOIN的类型存在。

for the merge statement that contains only the update clause or the delete clause, the inner join is performed between source and target table.

对于仅包含更新子句或删除子句的merge语句，内部联接会在源表与目标表之间执行。

inner join versus tables strung together in the from clause separated by commas

INNERJOINvsFROM子句中串在一起并用逗号分隔的表

an inner join is a type of join in which only those objects that have a match in the opposite data set are returned.

内部联接是仅返回在相对数据集中具有匹配对象的那些对象的一种联接类型。

change an inner join to an outer join

将内部联接更改为外部联接

you create an inner join by dragging a field from one data source to a field on another data source.

创建内部联接的方法是，将一个数据源中的字段拖动到另一个数据源中的字段上。

you join two tables by using an inner join or an outer join.

可以通过使用内连接或外连接来连接两个表。

the tables or views in the from clause can be specified in any order with an inner join or full outer join.

FROM子句中的表或视图可通过内部联接或完整外部联接按任意顺序指定。

namely, an inner join of the two tables will result in all people that have an office assignment.

也就是说，两个表的内部联接将导致所有人都会分配到办公室。

the logical operator that matches the physical operator, such as the inner join operator.

与物理运算符匹配的逻辑运算符，如InnerJoin运算符。

an inner join is a join in which the values in the columns being joined are compared using a comparison operator.

内部联接是使用比较运算符比较要联接列中的值的联接。

columns containing null do not match any values when you are creating an inner join and are therefore excluded from the result set.

当创建内部联接时，包含NULL的列不与任何值匹配，因此不包括在结果集内。

j is an inner join.

J是一个内部连接。

you can then use an sql inner join to get the frequency with which each company in the list is mentioned, as in listing 10.

然后您可以使用一个SQLinnerjoin语句来得到列表中每个公司被提到的频率，如清单10所示。

this inner join is known as an equi-join.

此内部联接称为同等联接。

is equivalent to inner join.

相当于内连接。

remember, these are counts for inner join.

记住，这些是内连接（INNERJOIN）的计数。

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语句）源与目标表行之间的联接。

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操作之间也可能发生类似的问题。

inner join is a join that presents rows that exist in the joined tables.

内连接表示存在于连接表中的行。

however, if a where clause is added, the cross join behaves as an inner join.

但是，如果添加了WHERE子句，则交叉联接的行为将与内部联接行为相似。

inner join based on the "greater than" operator.

基于“大于号”运算符的内部联接。

an inner join excludes rows from a source table that have no matching rows in the other source tables .

内部联接排除在其他源表中没有匹配行的源表中的行。

for example when using an inner join you compare two columns of different tables and test for equality.

例如，在使用INNERJOIN时，比较不同表的两个列，检查它们是否相等。

a join that displays only the rows that have a match in both joined tables is known as inner join.

在相联接的表中，如果只返回两表均匹配的行，该联接就是内联接。