求一insert语句！！在线等

[leoiv]

相关内容如下：我在vb中操作sql语句
data.mdb中包括表： a 表 ，b 表，c 表
表 a:
字段：no name num
值：111 wang 5
222 li 3
......

表 b:
字段：no name num jiage
值： 111 wang 15 1.20
222 li 10 3.00
......

表 c:
字段：no name num jiage
值：

实现目的: 把a.no,a.name,b.jiage 插入到表c。
条件 ： a.no=b.no
表c结果： c.no=a.no,c.name=a.name,c.num=a.num-b.num,c.jiage=b.jiage

注： 我的表a和表b记录有上万条。
请高手赐教！希望调试后把正确语句贴上，非常感谢！

[xiaoxiangqing]

insert into tableC
select a.no,a.name,a.num-b.num,b.jiage from tableA a join tableb b on a.no=b.no

[sntalk]

insert c(no,name,num,jiage)
select a.no, a.name, a.num-b.num as num, b.jiage from a inner join b on a.no=b.no and b.name=a.name

[WangZWang]

Insert Into C(no,name,num,jiage)
select a.no,a.name,a.num-b.num,b.jiage
from a inner join b on a.no=b.id

[Andy__Huang]

insert into 表C(no,name,num,jiage)
select a.no,a.name,a.num-b.num,b,jiage from a inner join b on a.no=b.no and a.name=b.name

[sankis]

insert C (no,name,num,jiage)
select a.no, a.name, a.num-b.num, b.jiage from a inner join b on a.no=b.no

[leoiv]

顺便说一句。我在程序中的表是这么打开的。
Private Sub Command7_Click()
Data3.DatabaseName = App.Path + "\" + "data.mdb"
Data3.RecordSource = "baobiao"
Data3.Refresh
On Error GoTo X8
Data3.Recordset.MoveLast
Data3.Recordset.MoveFirst
Data3.RecordSource = "data3.recordscinsert into baobiao(no,bianhao,mingcheng,jinjia,danwei,shuliang,sychayi,bychayi) select kcbaobiao.no,kcbaobiao.bb_no,kcbaobiao.bb_name,kcbaobiao.bb_jj,erpbaobiao.erp_dw,kcbaobiao.bb_num,kcbaobiao.bb_chayi,kcbaobiao.bb_num-erpbaobiao.erp_num from kcbaobiao inner join erpbaobiao on kcbaobiao.bb_no = erpbaobiao.erp_no"
MsgBox "计算完毕！", vbOKOnly
End Sub

这条语句对吗?
Data3.RecordSource = "data3.recordscinsert into baobiao(no,bianhao,mingcheng,jinjia,danwei,shuliang,sychayi,bychayi) select kcbaobiao.no,kcbaobiao.bb_no,kcbaobiao.bb_name,kcbaobiao.bb_jj,erpbaobiao.erp_dw,kcbaobiao.bb_num,kcbaobiao.bb_chayi,kcbaobiao.bb_num-erpbaobiao.erp_num from kcbaobiao inner join erpbaobiao on kcbaobiao.bb_no = erpbaobiao.erp_no"

[notin]

insert into table_c
select a.no,a.name,(a.num-b.num),b.jiage from table_a a inner join table_b b on a.no=b.no

[马前小卒]

insert into c
select a.no,a.name,(a.name-c.name),b.jiage from a,b where a.no=b.no

[meilian01]

insert into c
select a.no, a.name, a.num-b.num,b.jiage from a join on a.no = b.no