自己搞定拉 ----------------------------爽啊 SELECT TOP 100 PERCENT LEFT(dbo.zongkutab.bianhao, 5) AS Bianhao, SUM(dbo.xiaosetab.suliang) AS ZongSuliang, dbo.zongkutab.ypname, dbo.zongkutab.zongsu, dbo.view2.CanDi, dbo.view2.GuiGe, MIN(dbo.zongkutab.jinjia) AS jiajia, dbo.view2.cangjiabh FROM dbo.zongkutab INNER JOIN dbo.xiaosetab ON dbo.zongkutab.bianhao = dbo.xiaosetab.bianhao INNER JOIN dbo.view2 ON dbo.xiaosetab.bianhao = dbo.view2.BianHao WHERE (dbo.xiaosetab.xiaoserq BETWEEN GETDATE() - 30 AND GETDATE())'呵呵,这样来搞就可以哒,本来这是外部的变量来的,但我用变通的方法这样一测试,果然爽啊,爽啊! GROUP BY LEFT(dbo.zongkutab.bianhao, 5), dbo.zongkutab.zongsu, dbo.zongkutab.ypname, dbo.view2.CanDi, dbo.view2.GuiGe, dbo.view2.cangjiabh ORDER BY LEFT(dbo.zongkutab.bianhao, 5)
----------------------------爽啊
SELECT TOP 100 PERCENT LEFT(dbo.zongkutab.bianhao, 5) AS Bianhao,
SUM(dbo.xiaosetab.suliang) AS ZongSuliang, dbo.zongkutab.ypname,
dbo.zongkutab.zongsu, dbo.view2.CanDi, dbo.view2.GuiGe, MIN(dbo.zongkutab.jinjia)
AS jiajia, dbo.view2.cangjiabh
FROM dbo.zongkutab INNER JOIN
dbo.xiaosetab ON dbo.zongkutab.bianhao = dbo.xiaosetab.bianhao INNER JOIN
dbo.view2 ON dbo.xiaosetab.bianhao = dbo.view2.BianHao
WHERE (dbo.xiaosetab.xiaoserq BETWEEN GETDATE() - 30 AND GETDATE())'呵呵,这样来搞就可以哒,本来这是外部的变量来的,但我用变通的方法这样一测试,果然爽啊,爽啊!
GROUP BY LEFT(dbo.zongkutab.bianhao, 5), dbo.zongkutab.zongsu,
dbo.zongkutab.ypname, dbo.view2.CanDi, dbo.view2.GuiGe,
dbo.view2.cangjiabh
ORDER BY LEFT(dbo.zongkutab.bianhao, 5)