好像这样子啊!
ALTER PROCEDURE [dbo].[KeHu_jiben_DuoZhongFenLei_Reports_count]
AS
BEGIN
SELECT XT_DaQu.DaQuMingCheng AS DaQuMingCheng1, COUNT(XT_DaQu.DaQuMingCheng) AS KeHu_DaQu_Count
FROM XT_DaQu_ShengFen INNER JOIN
XT_DaQu ON XT_DaQu_ShengFen.DaQuDaiMa = XT_DaQu.DaQuDaiMa INNER JOIN
XT_DaQu_ShengFen_DiQu ON XT_DaQu_ShengFen.ShengFenDaiMa = XT_DaQu_ShengFen_DiQu.ShengFenDaiMa INNER JOIN
KeHu_JiBen ON XT_DaQu_ShengFen_DiQu.DiQuDaiMa = KeHu_JiBen.SuoZaiDiQuDaiMa
GROUP BY XT_DaQu.DaQuMingCheng
ORDER BY KeHu_DaQu_Count DESC
ENDDaQuMingCheng1 KeHu_DaQu_Count
华南 40
华北 10
华中 6
西南 3
西北 2
华东 1
东北 1
可是他不是这样子的啊!他是通过每个都是1/7啊!没有通过后面的count来进行啊!如果可以的话!大家帮帮我!我明天就有了 啊!老师很bt的啊!谢谢!希望 阿泰可以看到啊!