Question

vfp表的关联问题，求大神解答

现有4张表（分别为STU1.DBF，STU2.DBF，STU3.DBF和STU4.DBF），通过表的关联操作，显示表3 的stu_id，name，表4的>gender，表2的depa_name和表1的total等字段内容。





Answer 1

用命令文件即程序实现：
set talk off
set safe off
clear
close all
close database
sele 1
use stu1
index on stu_id to stu1
sele 2
use stu2
index on depa_id to stu2
sele 3
use stu3
index on stu_id to stu3
sele 4
use stu4
index on stu_id to stu4
sele 3
* set rela to stu_id into stu1
* set rela to depa_id into stu2 addi
* set rela to stu_id into stu4 addi
set rela to stu_id into a
set rela to depa_id into b addi
set rela to stu_id into d addi
list stu_id,name,a->total,b->depa_name,d->gender
return