三条语句
--出库
SELECT DISTINCT Name, SUM(sums) AS 出库数量, b.shebei, b.jiancheng FROM chuku AS chuku, Categories AS b WHERE chuku.name = b.type and DateTime between '2010-1-1' and '2010-8-6' GROUP BY name, b.shebei, b.jiancheng --库存
SELECT DISTINCT Storage_Name, SUM(Kuguan) AS 库存数量, b.shebei, b.jiancheng FROM kucun AS kucun, Categories AS b WHERE (Zhuguan = '1') and kucun.storage_name = b.type GROUP BY storage_name, b.shebei, b.jiancheng--入库
SELECT DISTINCT a.storage_Name, SUM(zhuguan)as 入库数量数量,b.shebei,b.jiancheng FROM Storage_main as a,Categories AS b where a.storage_Name = b.type and a.Storage_datetime between '2010-1-1' and '2010-8-8' and zhuguan = '1' GROUP BY a.storage_Name,b.shebei, b.jiancheng 组成一个表,查询结果产品名称 型号 简称 出库数量 库存数量 入库数量
--出库
SELECT DISTINCT Name, SUM(sums) AS 出库数量, b.shebei, b.jiancheng FROM chuku AS chuku, Categories AS b WHERE chuku.name = b.type and DateTime between '2010-1-1' and '2010-8-6' GROUP BY name, b.shebei, b.jiancheng --库存
SELECT DISTINCT Storage_Name, SUM(Kuguan) AS 库存数量, b.shebei, b.jiancheng FROM kucun AS kucun, Categories AS b WHERE (Zhuguan = '1') and kucun.storage_name = b.type GROUP BY storage_name, b.shebei, b.jiancheng--入库
SELECT DISTINCT a.storage_Name, SUM(zhuguan)as 入库数量数量,b.shebei,b.jiancheng FROM Storage_main as a,Categories AS b where a.storage_Name = b.type and a.Storage_datetime between '2010-1-1' and '2010-8-8' and zhuguan = '1' GROUP BY a.storage_Name,b.shebei, b.jiancheng 组成一个表,查询结果产品名称 型号 简称 出库数量 库存数量 入库数量
解决方案 »
- 发布之后,在Web.Config更改<httpHandlers>,出错是只读不能更改,
- girdview !!
- 最近要开发一小软件,要用到二维条码(PDF417),求相关控件或程序
- 点击datagrid,我怎么取出点击单元格中的内容,急,高手回答
- 如何利用CheckBoxList的选择与否来计算数值之和?(50份求助,不行在加!)
- 不懂了,100分求助!
- 使用DataGrid分页的几个问题请教!!!!
- 请大家帮忙看一下我这样对不对.
- Datalist 的一个简单问题 50分在线等
- Response.Write("<script>... 中如何识别服务器端控件?
- jquery form插件如何用?
- 请教:关于GridView控件自动生成select语句的问题
select 产品名称,型号,简称,出库数量,'库存数量'=(select count().......)
,'入库数量' = (select count()....) from ..........
省略的地方你在吧查询语句写上去就行了