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
select a.no,a.name,a.num-b.num,b.jiage
from a inner join b on a.no=b.id
解决方案 »
- 急急急急非常急~~~帮帮忙啊
- 你知道客齐集吗?
- 【Sql Server API】: 哪个API函数可以取得当前的存储过程返回的总记录条数?
- 一个让我郁闷的问题,但好象很简单,请各位大侠助忙。
- 执行"select name from Table"把第行name字段的值用“,”隔开变成一个字符串,不用存储过程能不能做到?
- 把for循环的select结果集 select显示出来
- mysql导出指定字段的数据
- sql远程服务器导入我本地的数据,为什么没有把存储过程导入进去呢,那怎么弄? 还原可以把储存过程弄进去吗,但是我没有权限啊。
- 在ORACLE中,DUAL这个表有什么用??
- 如何在数据库中实现按月对数据的统计
- 安装问题
- 请问SQL Server中的触发器是事务性的吗?
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
select a.no, a.name, a.num-b.num, b.jiage from a inner join b on a.no=b.no
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"
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
select a.no,a.name,(a.name-c.name),b.jiage from a,b where a.no=b.no
select a.no, a.name, a.num-b.num,b.jiage from a join on a.no = b.no
select a.no,a.name,a.num-b.num,b.jiage from tableA a join tableb b on a.no=b.no
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