联合查询的SQL语句写出来总说有错,帮一下忙哈!

tof

不用那么复杂,联合查询关键是每个查询列要相同.

yoyo2008

？？？？？？

没明白，具体怎么做呀？我现在是刚刚知道点儿，只要你说明白我就开窍啦！

cofe2000

我只会照着改改，还请版主明示

tof

select Year,Subscriber,Value from sheet1 union all

SELECT sheet1.Year & " 小计" AS 表达式1, "" as t,Sum([sheet1].[Value])AS ValueAll FROM sheet1 GROUP BY sheet1.Year & " 小计"

UNION ALL select "总计", "" as t,sum(Value) from sheet1 ORDER BY Year;

cofe2000

"" as t

还能这么用啊，多谢

yoyo2008

我怎么做不出来呀?帮忙看看错在哪里?

老提示:在联合查询中所选定的两个数据表或查询中的列数不匹配.

我想按"存档月份"小计,"存档年"总计

谢谢!

OoisHddJ.rar (42.3 KB, 下载次数: 11)

2005-4-25 16:03 上传

点击文件名下载附件
联合查询的SQL语句写出来总说有错,帮一下忙哈!

cofe2000

SELECT [Contract and Revenue(2002-2005)].[存档年Year], [Contract and Revenue(2002-2005)].[存档季Quarter], [Contract and Revenue(2002-2005)].[存档月份Month], [Contract and Revenue(2002-2005)].[区域/Area], [Contract and Revenue(2002-2005)].[客户编号/Subscriber Code], [Contract and Revenue(2002-2005)].[合同编号/ Contract Number], [Contract and Revenue(2002-2005)].[客户名称/ Subscriber Name], [Contract and Revenue(2002-2005)].[席位/小时License/Hour], [Contract and Revenue(2002-2005)].[月数/Months], [Contract and Revenue(2002-2005)].[合同金额/Contract Value], [Contract and Revenue(2002-2005)].[签约人/Handled By], [Contract and Revenue(2002-2005)].[开始日期Star Date], [Contract and Revenue(2002-2005)].[结束日期End Date], [Contract and Revenue(2002-2005)].[存档日期], [Contract and Revenue(2002-2005)].[回款金额Accepted], [Contract and Revenue(2002-2005)].[待收金额 Due], [Contract and Revenue(2002-2005)].[坏账Dead], [Contract and Revenue(2002-2005)].[备注 Remark] FROM [Contract and Revenue(2002-2005)]; union all

SELECT [Contract and Revenue(2002-2005)].[存档月份Month] & " 小计" AS 表达式1, "" as t1,"" as t2,"" as t3,"" as t4,"" as t5,"" as t6,"" as t7,"" as t8,"" as t9,"" as t10,"" as t11,"" as t12,"" as t13,"" as t14,"" as t15,"" as t16,Sum([Contract and Revenue(2002-2005)].[合同金额/Contract Value])AS ValueAll FROM [Contract and Revenue(2002-2005)] GROUP BY [Contract and Revenue(2002-2005)].[存档月份Month] & " 小计"

UNION ALL select "总计", "" as t1,"" as t2,"" as t3,"" as t4,"" as t5,"" as t6,"" as t7,"" as t8,"" as t9,"" as t10,"" as t11,"" as t12,"" as t13,"" as t14,"" as t15,"" as t16,sum([合同金额/Contract Value]) from [Contract and Revenue(2002-2005)] ORDER BY [存档年Year];

yoyo2008

"" as t1,"" 能解释一下是什么意思吗?

yoyo2008

[em06][em06][em06]

yoyo2008

试了,完全不对呀

明细

此月小计

明细

此月小计

可做出来是乱的

我哭求我要求的结果!