You join two tables by using an inner join or an outer join.
可以通过使用内连接或外连接来连接两个表。
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所示。
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语句)源与目标表行之间的联接。
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语句，内部联接会在源表与目标表之间执行。
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 a type of join in which only those objects that have a match in the opposite data set are returned.
内部联接是仅返回在相对数据集中具有匹配对象的那些对象的一种联接类型。
Columns containing NULL do not match any values when you are creating an inner join and are therefore excluded from the result set.
当创建内部联接时，包含NULL的列不与任何值匹配，因此不包括在结果集内。
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，其中单词与公司名匹配。
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)的值来匹配表。
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表中的记录(因为这些记录具有空的或无效的坐标)。
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.
默认情况下，相关表通过使用内部联接进行联接，该内部联接基于包含联接列中匹配信息的行创建结果集。
Table and use an AS clause to name these columns for the display with the ij tool. Because the query joins these two tables (by using an implicit inner join), you can select columns from both tables.
因为查询(通过使用隐式内连接)将两个表连接，您可以从两个表中选择列。
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，这一事实也表明有另一种称作OUTER JOIN的类型存在。
The fact that this is also called an INNER JOIN might also indicate that an alternative called OUTER JOIN exists.
这也被称为INNER JOIN，这一事实也表明有另一种称作OUTER JOIN的类型存在。
应用推荐