the following transact-sql query is an example of an inner join

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

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

互联网摘选

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

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

互联网摘选

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 based on the "greater than" operator.

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

互联网摘选

is equivalent to inner join.

相当于内连接。

互联网摘选

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

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

互联网摘选

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

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

互联网摘选

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

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

互联网摘选

for more information about inner join syntax, see the topic inner join operation.

有关内部联接语法的详细信息，请参阅主题INNERJOIN操作。

互联网摘选

most of the time, you don't need to do anything to use an inner join.

在大多数情况下，不需要执行任何操作即可使用内部联接。

互联网摘选

in the tableadapter configuration wizard, you use query builder to design a query that contains an inner join.

在TableAdapter配置向导，使用查询生成器来设计查询包含内部联接。

互联网摘选

the entity type represents an inner join of the two tables.

该实体类型表示两个表的内部联接。

互联网摘选

use an inner join if you want to return only those rows from both tables in the join that match on the joining field .

如果您希望只返回联接的两个表中其联接字段彼此匹配的那些行，则使用内部联接。

互联网摘选

which can now be efficiently optimized as an inner join query.

该查询现在可以作为内部连接查询进行有效的优化。

互联网摘选

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

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

互联网摘选

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

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

互联网摘选

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

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

互联网摘选

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 join that displays only the rows that have a match in both joined tables is known as inner join.

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

互联网摘选