如果联接键是一个复合键，那么必须使用PRIOR运算符为每个键所在的列加上前缀。
If the join key is a composite key, each key column must be prefixed with the PRIOR operator.
为了合并扫描联接正确地执行，按照联接列的顺序预计有两个输入。
For the merge scan join to perform properly, both inputs are expected to be in the order of join columns.
对于客户类型来说，在JLT_T077D上使用其相应的支持数据来联接来自E2KNA1M 005表的列ktokd，使用KTOKD作为联接键。
For customer type, join the column KTOKD from the E2KNA1M005 table with its corresponding supporting data in JLT_T077D, using KTOKD as the join key.
如果为联接条件中的列建立了索引，则联接运行速度最快。
Joins work fastest if the columns in the join condition have been indexed.
还有其他行中列customer_num的值为10，其与目标表中的相同行联接。
There is another row in the source table with a value of 10 for the customer_num column, which joins with the same row in the target table.
在某些情况下，联接非索引列会使查询速度变慢。
In some cases, joining on unindexed columns can result in a slow query.
密集架系统，是一种由多列货柜架体密集组成，并通过专用轨道相互联接的密集货柜系统。
Compact shelving system is a kind of compact container system composed of multi goods shelf densely and joined each other by special tracks.
查询和视图设计器根据具有相同名称和数据类型的列仅创建一个联接。
The Query and View Designer will create only one join based on columns with the same name and data type.
当创建内部联接时，包含NULL的列不与任何值匹配，因此不包括在结果集内。
Columns containing NULL do not match any values when you are creating an inner join and are therefore excluded from the result set.
默认情况下，相关表通过使用内部联接进行联接，该内部联接基于包含联接列中匹配信息的行创建结果集。
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.
如果可以创建多个联接，查询和视图设计器在根据所找到的第一组匹配列创建一个联接后即会停止。
If more than one join is possible, the Query and View Designer stops after creating a join based on the first set of matching columns that it finds.
将其他两个表中的主键列都复制到联接表中。
Copy the primary key columns from each of the other two tables to the junction table.
显示选定联接的名称，该名称由联接所涉及的两个列的名称组成。
Shows the name of the selected join, which is composed of the names of the two columns involved in the join.
显示选定联接的名称，该名称由联接所涉及的两个列的名称组成。
Shows the name of the selected join, which is composed of the names of the two columns involved in the join.
应用推荐