天软的表格连接,join,full join,left join,right join等都可以做多表连接。
下面以join为例,实现三个表格的连接,具体如下:
注意:select 后面的字段是最终表格返回的字段,当返回的字段中出现相同列名时,若不进行重命名,后面字段的值会覆盖前面字段的值。
表格代码:
Table1:=array(('A':1,'B':2,'C':7),
('A':10,'B':3,'C':12),
('A':10,'B':20,'C':12),
('A':4,'B':20,'C':34),
('A':4,'B':10,'C':4));
Table2:=Array(('A':10,'B':10,'D':3),
('A':15,'B':20,'D':3),
('A':4,'B':10,'D':3),
('A':5,'B':10,'D':3));
Table3:=Array(('A3':10,'E':10),
('A3':15,'E':30),
('A3':4,'E':20),
('A3':25,'E':20));
t:= select [1].*,[2].['A'] as 'A2',[2].['B'] as 'B2',[2].['D'],[3].*
from Table1
join Table2 on [1].['A']=[2].['A']
join Table3 on [1].['A']=[3].['A3']
end;
return t;
返回:
A | B | C | A2 | B2 | D | A3 | E
|
---|
10 | 3 | 12 | 10 | 10 | 3 | 10 | 10
|
10 | 20 | 12 | 10 | 10 | 3 | 10 | 10
|
4 | 20 | 34 | 4 | 10 | 3 | 4 | 20
|
4 | 10 | 4 | 4 | 10 | 3 | 4 | 20
|