片语

tableB INNER JOIN内联接

INNER JOIN ON内连接

A inner join B查询出来是A

equi-inner join内连接

inner INNER JOIN使用键的交集

INNER JOIN Class c内联接

SQL INNER JOIN关键字

inner r join内联接

NATURAL INNER JOIN自然连接

英汉例句

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

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

• in the current simple scheme, the process is simple; listing 5 performs an implicit inner join of the bigdog.products table and the bigdog.vendors

  在当前的简单模式中，过程十分简单；清单5执行bigdog.products表和bigdog.vendors表之间的隐式内连接。

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

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

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

• also at the time of this article?s writing, the joinrowsetimpl class only implemented the ability to perform an inner join like that showcased in this article.

  同样是在本文编写之际，joinrowsetimpl类只实现了执行内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.

  下面的概念图显示了两个集合中的完整项目，以及这两个集合彼此进行内部联结或左外部联结之后剩下的项目。

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

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

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

  这也被称为inner join，这一事实也表明有另一种称作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语句，内部联接会在源表与目标表之间执行。

• for a nullable joined column, is it better performance to do a outer join, or inner join to a 「null」 row?

  一个空连接柱，它是更好的性能做了一个外连接，或内加入一个「空」行吗？

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

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

• 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.

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

• by default, related tables are joined using an inner join that creates a result set based on rows containing matching information in the join columns.

  默认情况下，相关表通过使用内部联接进行联接，该内部联接基于包含联接列中匹配信息的行创建结果集。

• 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之间的inner join，其中单词与公司名匹配。