inner join

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

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

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）的值来匹配表。

Remember , these are counts for INNER join .

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

For example when using an INNER JOIN you compare two columns of different tables and test for equality .

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

INNER JOIN versus tables strung together in the FROM clause separated by commas

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

J is an inner join .

J是一个内部连接。

This inner join is known as an equi-join .

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

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语句，内部联接会在源表与目标表之间执行。

This example uses a SELECT query that defines the inner join between WordFrequency and Companies , where the word matches the name of the company .

本例使用SELECT查询，它定义了WordFrequency和Companies之间的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语句）源与目标表行之间的联接。

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表中但没有出现在wellspts表中的记录（因为这些记录具有空的或无效的坐标）。

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 .

也就是说，联接操作的内部表将被扫描8次，来自外部输入的8个合格的记录每个都将被扫描一次。

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

This registry variable causes the optimizer to favor nested loop joins to join the list of values , using the table that contributes the IN list as the inner table in the join .

这个注册表变量会导致优化器优先使用嵌套循环连接来连接值列表，使用为IN列表提供值的表作为连接的内部表。