zhuyiwen近来

tianshi

SELECT 奶牛登记卡.所在乡镇, Sum(奶牛登记卡.奶牛存栏) AS 奶牛存栏之Sum, Sum(奶牛登记卡.可繁) AS 可繁之Sum, Sum(奶牛登记卡.育成) AS 育成之Sum, Sum(奶牛登记卡.泌乳) AS 泌乳之Sum, Sum(奶牛登记卡.犊牛) AS 犊牛之Sum, Sum(奶牛登记卡.青贮窖) AS 青贮窖之Sum, Sum(奶牛登记卡.青贮量) AS 青贮量之Sum, Sum(奶牛登记卡.牛舍面积) AS 牛舍面积之Sum, Sum(奶牛登记卡.[2001年商品奶量]) AS 2001年商品奶量之Sum, Sum(奶牛登记卡.[2002年预计商品奶量]) AS 2002年预计商品奶量之Sum
FROM 奶牛登记卡
GROUP BY 奶牛登记卡.所在乡镇
HAVING (((奶牛登记卡.所在乡镇)="二道湾镇" Or (奶牛登记卡.所在乡镇)="友谊乡" Or (奶牛登记卡.所在乡镇)="富裕镇" Or (奶牛登记卡.所在乡镇)="龙安桥镇" Or (奶牛登记卡.所在乡镇)="繁荣乡" Or (奶牛登记卡.所在乡镇)="绍文乡" Or (奶牛登记卡.所在乡镇)="忠厚乡" Or (奶牛登记卡.所在乡镇)="塔哈乡" Or (奶牛登记卡.所在乡镇)="富路镇" Or (奶牛登记卡.所在乡镇)="富海镇"));

这是个按地址所建立的查询，要查询出10各不同地点的合计数，我的问题是在这个查询中，求出10各地点的总合。包括里面的每一个项目。

access91

SELECT 奶牛登记卡.所在乡镇, Sum(奶牛登记卡.奶牛存栏) AS 奶牛存栏之Sum, Sum(奶牛登记卡.可繁) AS 可繁之Sum, Sum(奶牛登记卡.育成) AS 育成之Sum, Sum(奶牛登记卡.泌乳) AS 泌乳之Sum, Sum(奶牛登记卡.犊牛) AS 犊牛之Sum, Sum(奶牛登记卡.青贮窖) AS 青贮窖之Sum, Sum(奶牛登记卡.青贮量) AS 青贮量之Sum, Sum(奶牛登记卡.牛舍面积) AS 牛舍面积之Sum, Sum(奶牛登记卡.[2001年商品奶量]) AS 2001年商品奶量之Sum, Sum(奶牛登记卡.[2002年预计商品奶量]) AS 2002年预计商品奶量之Sum
FROM 奶牛登记卡
GROUP BY 奶牛登记卡.所在乡镇
HAVING (((奶牛登记卡.所在乡镇)="二道湾镇" Or (奶牛登记卡.所在乡镇)="友谊乡" Or (奶牛登记卡.所在乡镇)="富裕镇" Or (奶牛登记卡.所在乡镇)="龙安桥镇" Or (奶牛登记卡.所在乡镇)="繁荣乡" Or (奶牛登记卡.所在乡镇)="绍文乡" Or (奶牛登记卡.所在乡镇)="忠厚乡" Or (奶牛登记卡.所在乡镇)="塔哈乡" Or (奶牛登记卡.所在乡镇)="富路镇" Or (奶牛登记卡.所在乡镇)="富海镇")) union
SELECT "heji" as a, Sum(奶牛登记卡.奶牛存栏) AS 奶牛存栏之Sum, Sum(奶牛登记卡.可繁) AS 可繁之Sum, Sum(奶牛登记卡.育成) AS 育成之Sum, Sum(奶牛登记卡.泌乳) AS 泌乳之Sum, Sum(奶牛登记卡.犊牛) AS 犊牛之Sum, Sum(奶牛登记卡.青贮窖) AS 青贮窖之Sum, Sum(奶牛登记卡.青贮量) AS 青贮量之Sum, Sum(奶牛登记卡.牛舍面积) AS 牛舍面积之Sum, Sum(奶牛登记卡.[2001年商品奶量]) AS 2001年商品奶量之Sum, Sum(奶牛登记卡.[2002年预计商品奶量]) AS 2002年预计商品奶量之Sum
FROM 奶牛登记卡
GROUP BY "heji"
where (((奶牛登记卡.所在乡镇)="二道湾镇" Or (奶牛登记卡.所在乡镇)="友谊乡" Or (奶牛登记卡.所在乡镇)="富裕镇" Or (奶牛登记卡.所在乡镇)="龙安桥镇" Or (奶牛登记卡.所在乡镇)="繁荣乡" Or (奶牛登记卡.所在乡镇)="绍文乡" Or (奶牛登记卡.所在乡镇)="忠厚乡" Or (奶牛登记卡.所在乡镇)="塔哈乡" Or (奶牛登记卡.所在乡镇)="富路镇" Or (奶牛登记卡.所在乡镇)="富海镇"));

zhuyiwen

SELECT 奶牛登记卡.所在乡镇, "合计" as 合计, Sum(奶牛登记卡.奶牛存栏) AS 奶牛存栏, Sum(奶牛登记卡.可繁) AS 可繁, Sum(奶牛登记卡.育成) AS 育成, Sum(奶牛登记卡.泌乳) AS 泌乳之, Sum(奶牛登记卡.犊牛) AS 犊牛, Sum(奶牛登记卡.青贮窖) AS 青贮窖, Sum(奶牛登记卡.青贮量) AS 青贮量, Sum(奶牛登记卡.牛舍面积) AS 牛舍面积, Sum(奶牛登记卡.[2001年商品奶量]) AS 2001年商品奶量, Sum(奶牛登记卡.[2002年预计商品奶量]) AS 2002年预计商品奶量
FROM 奶牛登记卡
GROUP BY 奶牛登记卡.所在乡镇
HAVING (((奶牛登记卡.所在乡镇)="二道湾镇" Or (奶牛登记卡.所在乡镇)="友谊乡" Or (奶牛登记卡.所在乡镇)="富裕镇" Or (奶牛登记卡.所在乡镇)="龙安桥镇" Or (奶牛登记卡.所在乡镇)="繁荣乡" Or (奶牛登记卡.所在乡镇)="绍文乡" Or (奶牛登记卡.所在乡镇)="忠厚乡" Or (奶牛登记卡.所在乡镇)="塔哈乡" Or (奶牛登记卡.所在乡镇)="富路镇" Or (奶牛登记卡.所在乡镇)="富海镇"));

UNION SELECT 所在乡镇, "" as 合计, 奶牛存栏, 可繁, 育成, 泌乳, 犊牛, 青贮量, 青贮窖, 牛舍面积, [2001年商品奶量], [2002年预计商品奶量]
FROM 奶牛登记卡
WHERE (((奶牛登记卡.所在乡镇)="二道湾镇" Or (奶牛登记卡.所在乡镇)="友谊乡" Or (奶牛登记卡.所在乡镇)="富裕镇" Or (奶牛登记卡.所在乡镇)="龙安桥镇" Or (奶牛登记卡.所在乡镇)="繁荣乡" Or (奶牛登记卡.所在乡镇)="绍文乡" Or (奶牛登记卡.所在乡镇)="忠厚乡" Or (奶牛登记卡.所在乡镇)="塔哈乡" Or (奶牛登记卡.所在乡镇)="富路镇" Or (奶牛登记卡.所在乡镇)="富海镇"))
ORDER BY 所在乡镇;

哈哈，与楼上老兄同出一辙！

[此贴子已经被zhuyiwen于2002-4-13 15:47:46编辑过]

tmtony

我看着眼有点晕
好象到处都是奶牛呢 ：）

大熊

富裕镇,繁荣乡，真是这名字吗？太好笑了！

zhuyiwen

哈哈~~~~