A:=Array();
B:=array();
For i:=0 to 99 do
begin
A[i][“ABCD”]:=Random();
A[i][“INDEX”]:=i;
B[i][“ABCD”]:=random();
B[i][“INDEX”]:=i;
End;
ReturnSelect * from A join B On [1].[“INDEX”] = [2].[“INDEX”] end;