update mrequest
set shortage = mrequest.mrqty - passout.outqty + passin.inqty + rein.reqtyin
from mrequest, passout, passin, rein
where mrequest.mrno = passout.mrno
and mrequest.mrno = passin.mrno
and mrequest.mrno = rein.mrno
and mrequest.partno = passout.partno
and mrequest.partno = passin.partno
and mrequest.partno = rein.partno
set shortage = mrequest.mrqty - passout.outqty + passin.inqty + rein.reqtyin
from mrequest, passout, passin, rein
where mrequest.mrno = passout.mrno
and mrequest.mrno = passin.mrno
and mrequest.mrno = rein.mrno
and mrequest.partno = passout.partno
and mrequest.partno = passin.partno
and mrequest.partno = rein.partno
解决方案 »
- sql server 2005查询结果 导出为EXCEL
- SQL 错误提示语句怎么写
- 帮忙调试一下这段语句,谢谢!
- 我做的web系统,为什么一有人做数据统计就提示无法连接数据库了啊,是sqlserver2005
- 通用存储过程怎样返回记录总数
- 怎么批量去除字段里的空格?
- Sql只有sa帐户能连上,windows帐户却不行?
- SQLSERVER T-SQL 自定义函数 不是可以识别的函数名 消息 208,级别 16
- 在VB中调用存储过程问题
- 把一个存储过程设置为自动启动(SQL启动时执行)?
- 将一个表中的数据转移到另一个表中;如何写这个SQL??
- 写好的一个创建数据库的SQL语句,怎样在SQL SERVER2000下运行并建立一个数据库?
set shortage = mrequest.mrqty - passout.outqty + passin.inqty + rein.reqtyin
from passout a,passin b,rein c
where mrequest.mrno=a.mrno and mrequest.partno=a.partno and
a.mrno=b.mrno and a.partno=b.partno and
b.mrno=c.mrno and b.partno=c.partno
set shortage = mrequest.mrqty - a.outqty + b.inqty + c.reqtyin
from passout a,passin b,rein c
where mrequest.mrno=a.mrno and mrequest.partno=a.partno and
a.mrno=b.mrno and a.partno=b.partno and
b.mrno=c.mrno and b.partno=c.partno
update mrequest set shortage=d.mrqty-a.outqty+b.inqty+reqtyin
from mrequest d,passout a,passin b,rein c
where d.mrno=a.mrno and d.partno=a.partno
and d.mrno=b.mrno and d.partno=b.partno
and d.mrno=c.mrno and d.partno=c.partno
from mrequest,passout,passin,rein
where mrequest.mrno=passout.mrno and mrequest.partno=passout.partno
and mrequest.mrno=passin.mrno and mrequest.partno=passin.partno
and mrequest.mrno=rein.mrno and mrequest.partno=rein.partno
from mrequest d,
(select mrno,sum(outqty) outqty from passout group by mrno) a,
(select mrno,sum(inqty ) inqty from passin group by mrno) b,
(select mrno,sum(reqtyin) reqty from rein group by mrno) cwhere d.mrno=a.mrno and d.partno=a.partno
and d.mrno=b.mrno and d.partno=b.partno
and d.mrno=c.mrno and d.partno=c.partno
服务器: 消息 207,级别 16,状态 3,行 1
列名 'reqtyin' 无效。
服务器: 消息 207,级别 16,状态 1,行 1
列名 'partno' 无效。
服务器: 消息 207,级别 16,状态 1,行 1
列名 'partno' 无效。
服务器: 消息 207,级别 16,状态 1,行 1
列名 'partno' 无效。等待...
from mrequest d,
(select mrno,sum(outqty) outqty from passout group by mrno,partno) a,
(select mrno,sum(inqty ) inqty from passin group by mrno,partno) b,
(select mrno,sum(reqtyin) reqtyin from rein group by mrno,partno) cwhere d.mrno=a.mrno and d.partno=a.partno
and d.mrno=b.mrno and d.partno=b.partno
and d.mrno=c.mrno and d.partno=c.partno