vfp中合并两个关联表组成新的临时表

Question

vfp中有两个表，电表和用电户表，字段如下
电表        ID                             num    
              411528101001         413001452528524558
              411528101002         413002510002530145
用电户    name            code                   address                 ID
               张三             52526324           文博花园1单元       411528101001
               李四             52638847           文博花园2单元       411528101002合成新的临时表   电表信息
                            ID                            num                               name           code                    address
                            411528101001       413001452528524558    张三             52526324           文博花园1单元  
                            411528101002      413002510002530145     李四             52638847           文博花园2单元       
用 select 表1.字段1，表1.字段2，表2.字段1 from 表1，表2 where  表1.ID=表2.ID，新的临时表可以出来但是没有数据，请教各位大神怎么做才能生成上述表

Answer 1

https://blog.csdn.net/u010498402/article/details/78038553