三个表记录数一样
处理效果应该入下
a记录1
b记录1
c记录1
a记录2
b记录2
c记录2
   .
   .
   .
a记录n
b记录n
c记录n

如果记录数不是很大，各表逐个记录读出再写到新表就可以，这样简单易明。
如果记录数很大，各表可添加一序号字段并写好记录的序号，APPEND到一起再按序号索引一下就OK。

版主能给个代码吗？我对这块了解不多，求指导。

select bh,"a"+padl(recno(),4,"0") xh from a union all select bh,"b"+padl(recno(),4,"0") from b union all select bh,"c"+padl(recno(),4,"0") from b order by 2

多谢sdta指导，顺序应该这样排列

 CLOSE DATABASES

 SET SAFETY off


 SELECT 0

 USE a

 SELECT 0

 USE b

 SELECT 0

 USE c

 SELECT bh,SPACE(5) as xh from a where 1=2 into table hzb

 FOR i=1 to 3300
   FOR ii=1 to 3
     SELECT hzb
     IF ii=1
       APPEND FROM a for RECNO()=i
       REPLACE xh with 'a'+SUBSTR(ALLTRIM(STR(10000+i)),2)
     ELSE
       IF ii=2
         APPEND FROM b for RECNO()=i
         REPLACE xh with 'b'+SUBSTR(ALLTRIM(STR(10000+i)),2)
       ELSE
         APPEND FROM c for RECNO()=i
         REPLACE xh with 'c'+SUBSTR(ALLTRIM(STR(10000+i)),2)
       ENDIF
     ENDIF
   ENDFOR

 ENDFOR 

我的土法看起来，好理解一点吧

谢谢wengjl  虽然处理速度有点慢，目的达到了。多谢。

在4楼代码的基础上
select bh,"a"+padl(recno(),4,"0") xh from a union all select bh,"b"+padl(recno(),4,"0") from b union all select bh,"c"+padl(recno(),4,"0") from b into table ls
use ls

inde on righ(xh,4) to ls0
就可达到此要求
6楼方法太慢了。

select bh,"a"+padl(recno(),4,"0") xh from a union all select bh,"b"+padl(recno(),4,"0") from b union all select bh,"c"+padl(recno(),4,"0") from c into cursor abc
index on right(xh,4) tag aa
copy to aa fields bh
use aa
browse
use

SELECT bh,SPACE(5) as xh from a where .F. into table hzb
FOR i=1 to 3300
    APPEND FROM a for RECNO()=i
    APPEND FROM b for RECNO()=i
    APPEND FROM c for RECNO()=i
ENDFOR
BROWSE

[ 本帖最后由 sdta 于 2015-7-15 17:22 编辑 ]