Try adding a numeric sort on key field 1 to see how to change this.
尝试对关键字段1添加一个数值排序，看看如何改变这个结果。
Since text2 is not sorted in numeric order, we could sort it and then join would join the two lines that have a matching join field (the field with value 3 in this case).
由于text2并不是按数值排序的，因此可以对它进行排序并使用join命令将具有匹配的join字段(在本例中指值为3的字段)的两行连接起来。
Fortunately, the sort command can sort by numeric values or by character values.
幸运的是，sort命令可以按照数字值或字符值进行排序。
Use a Number or Currency field to sort numbers as numeric values.
使用“数字”或“货币”字段按照数字值对数字进行排序。
Use a Number or Currency field to sort numbers as numeric values.
使用“数字”或“货币”字段按照数字值对数字进行排序。
应用推荐