select a.入库单编号,sum(isnull(b.入库费用,0)) as 入库费用
from 表1 a left join 表2 b on a.入库单编号=b.入库单编号
from 表1 a left join 表2 b on a.入库单编号=b.入库单编号
解决方案 »
- 这条sql哪里有问题??
- 请教个简单sql语句(在线等)
- 我疯啦,怎么也想不通的一个存储过程
- 大虾帮看一下,谢谢。
- 转换成函数
- 在win7 64bit下安装sql server 2005的问题
- 索引高手请进
- 求助!!!!!
- 在SQL Server7.0中,我对一个表做了一个UPDATE触发器,把修改过的数据放入一个临时表中。可是每次我从Enterprise Manger中打开该表,手工个修改其中内容的时侯,无论做多少次,临时表中始终放的是最最原始的那个数据,这是为什么?
- 未与信任 SQL Server 连接相关联,只有某台机器可以连接
- 在一个存储过程里能用临时表接受另外一个存储过程返回的表吗?
- 开机问题
from 表1 a left join 表2 b on a.入库单编号=b.入库单编号
group by a.入库单编号
from 表1 a left join 表2 b on a.入库单编号=b.入库单编号
group by a.入库单编号
下面这样怎么错呢?
SELECT masterstorage.cStorageNo,
masterstorage.cStorageDate,
masterstorage.cweightman,
masterstorage.chandleman,
masterstorage.cstoragemethod,
goodsmaster.goodsmastername,
t_b_qtfy.ify as aafy,
detailstorage.istorageamount,
detailstorage.iweight,
detailstorage.totalfy,
detailstorage.izxfy,
detailstorage.ixjfy,
detailstorage.ijcfy,
detailstorage.iqtfy
FROM masterstorage,detailstorage,goodsmaster left join t_b_qtfy on
(detailstorage.cstorageno=t_b_qtfy.cstorageno) and
(detailstorage.cstorageno=masterstorage.cstorageno) and
(detailstorage.cstorageno=t_b_qtfy.cstorageno) and
(masterstorage.cgoodsmasterno=goodsmaster.goodsmasterno) and
( masterstorage.bsh = 1 ) AND
( masterstorage.bzx = 0 ) and
( masterstorage.cStorageDate>='2001-01-01') and
( masterstorage.cStorageDate<='2009-01-01') and
( masterstorage.cgoodsmasterno='7') and
(masterstorage.cstorageno not in (select cinstart from jiaokuairizhi))