1. 表
A
X1 X2 X3
1 11 111
3 33 333
2 22 222
B
Y1 AX1 Y3
20 2 F
30 3 G
10 1 E
2. 排序
A
X1 X2 X3
1 11 111
2 22 222
3 33 333
B
Y1 AX1 Y3
10 1 E
20 2 F
30 3 G
3. 顺序关联
var rowIndex = 0
for(var i=0;i<A.ROW.LENGTH;i++){
for(var j=rowIndex;j<A.ROW.LENGTH;j++){
if(A.ROW[i].X1==B.ROW[j].AX1){
process(A.ROW[i], B.ROW[j])
}else{
rowIndex = j;
break;
}
}
}