回复 8楼 yd1954
改成如下代码，试一试哈
程序代码：clear all use b1 shared use b2 select * from b1 into table _t2 alter table _t2 drop column qihao alter table _t2 drop column h1 alter table _t2 drop column h2 alter table _t2 drop column h3 alter table _t2 rename column xh to xh2 select xh,h1,h2,h3 from b1 where h1 = 0 into table _t1 select _t1.*,_t2.* from _t1 left join _t2 on _t1.xh - 1 = _t2.xh2 into table B2
