在线求解个报表SQL问题.
我先放SQL语句.
SELECT L.WLMC,
L.FHDWMC,
L.SHDWMC,
TO_CHAR(SUM(L.jljz), 'fm9999990.0009') SUTTLE,
(SELECT TO_CHAR(SUM(M.jljz), 'fm9999990.0009') YSUTTLE
FROM TB_MS0303 M
WHERE M.YBLX = '6'
AND M.WLMC = L.WLMC
--and M.QCHID=L.QCHID
AND M.IS_VALID = '0'
AND M.MZJLBZ = '1'
AND M.PZJLBZ = '1'
AND M.JZSJ BETWEEN TO_DATE('2011-12-26', 'YYYY-MM-DD') AND
TO_DATE('2012-05-25', 'YYYY-MM-DD') + 1
AND QYBM = '100161') YSUTTLE
FROM TB_MS0303 L
WHERE L.YBLX = '6'
AND L.IS_VALID = '0'
AND MZJLBZ = '1'
AND PZJLBZ = '1'
AND L.JZSJ BETWEEN TO_DATE('2012-4-26', 'YYYY-MM-DD') AND
TO_DATE('2012-05-25', 'YYYY-MM-DD') + 1
AND QYBM = '100161'
GROUP BY WLMC, FHDWMC, SHDWMC
ORDER BY WLMC
这是一个月报表的SQL.现在查询出来的结果因为WLMC里面有三条数据都为同一个物料.
所以查询出来的结果YSUTTLE结果就相同.所以数据就不对.
这条SQL应该怎么改阿..
我试了下用其他的条件字段.但是结果集更加不对了.
在线等好心人.
[解决办法]
该回复于2012-05-26 17:27:20被版主删除
[解决办法]
只了解SQL2000 看不懂这个
[解决办法]
什么数据库
贴建表及插入记录的SQL，及要求结果出来看看
[解决办法]
看不懂
[解决办法]
看不懂！能发个简单有注释的例子吗？
[解决办法]
SELECT L.WLMC,
L.FHDWMC,
L.SHDWMC,
TO_CHAR(SUM(L.jljz), 'fm9999990.0009') SUTTLE,
(SELECT distinct TO_CHAR(SUM(M.jljz), 'fm9999990.0009') YSUTTLE
FROM TB_MS0303 M
WHERE M.YBLX = '6'
AND M.WLMC = L.WLMC
--and M.QCHID=L.QCHID
AND M.IS_VALID = '0'
AND M.MZJLBZ = '1'
AND M.PZJLBZ = '1'
AND M.JZSJ BETWEEN TO_DATE('2011-12-26', 'YYYY-MM-DD') AND TO_DATE('2012-05-25', 'YYYY-MM-DD') + 1
AND QYBM = '100161') YSUTTLE
FROM TB_MS0303 L
WHERE L.YBLX = '6'
AND L.IS_VALID = '0'
AND MZJLBZ = '1'
AND PZJLBZ = '1'
AND L.JZSJ BETWEEN TO_DATE('2012-4-26', 'YYYY-MM-DD') AND
TO_DATE('2012-05-25', 'YYYY-MM-DD') + 1
AND QYBM = '100161'
GROUP BY WLMC, FHDWMC, SHDWMC
ORDER BY WLMC
[解决办法]
看不明白~~~~这字段看起来都差不多。。。
