vfp6.0 一个表的部分字段根据条件插入到另一个表

[wang_yang188]

表A
khbm khmc dz
1101000 wer www
1120000 ddd www
1120001 eee aaa
1121000 rrr eee

表B
khbm zj rq1 rq2


我想把表A里khbm='112'的客户插入到表B中，同时zj=1.050,rq1='20091101',rq2='20091231'
应该咋处理？谢谢

[十豆三]

*vfp9.0以下

Select Khbm,1.050 As Zj,'20091101' As rq1,'20091231' As rq2 Into Curosr T1 From 表A Where khbm='112'
Use 表B In 0
Select 表B
Append From Dbf('T1')

[十豆三]

*vfp9.0

Insert Into 表B Select Khbm,1.050 As Zj,'20091101' As rq1,'20091231' As rq2 Into Curosr T1 From 表A Where khbm='112'