FETCH(3)的结果集是根据ID字段排序的，并且使用T1的索引I1的合并联接而得到最终的结果集。
The result set from FETCH (3) is ordered by the ID column and joined using a merge join with index I1 for T1 to get final result set.
图22显示了使用Concat功能联接为单个字段的两个字段。
Figure 22 shows two fields using the Concat function to join into one single field.
确保表与表之间相互联接的字段具有相同的数据类型和大小。
Ensure that joined fields between tables are of the same data type and size.
一种联接，其中涉及到使一种关系字段中的数值与另一种关系相对应字段中的数值相等的联接。
A join that involves matching values in a field from one relation with those in a corresponding field in another relation .
通过为联接两端的字段以及用于设置查询条件的字段创建索引，可以极大地提高查询的速度。
You can make dramatic improvements in the speed of a query by indexing fields that are on both sides of joins, and fields that are used to set criteria for the query.
通过为联接两端的字段以及用于设置查询条件的字段创建索引，可以极大地提高查询的速度。
You can make dramatic improvements in the speed of a query by indexing fields that are on both sides of joins, and fields that are used to set criteria for the query.
应用推荐