DECLARE A_cur CURSOR FOR
SELECT DISTINCT A FROM table_name WHERE query_cause //选取所有的字段A
LET x=1
LET y=1
FROEACH A_cur INTO Array[x][y] //foreach是循环取字段A值
DECLARE B_cur CURSOR FOR
SELECT B FROM table_name WHERE 字段A=Array[x][y] //选取字段B
FOREACH B_cur INTO Aarray[x][y] //以[A][B]的形式保存在数组中
LET y=y+1 //使y的值加1,以便保存下一个B的值
END FOREACH
LET x=x+1 //这样[1][1]=xxx,[1][2]=YYY
LET y=1
END FOREACH