(SELECT zzjg.Zg_name, zzjg.ZzjgID, COUNT(*) AS 个数, SUM(Gongcheng.Gc_GuimoValue)
AS 面积, SUM(Gongcheng.Gc_Jzzj) AS 造价
FROM Gongcheng INNER JOIN
zzjg ON Gongcheng.ZzjgID = zzjg.ZzjgID
WHERE (Gongcheng.Gc_Guimo = '面积')
GROUP BY zzjg.ZzjgID, zzjg.Zg_name) dange LEFT OUTER JOIN
(SELECT zzjg.ZzjgID, COUNT(*) AS 市标个数, SUM(Gongcheng.Gc_GuimoValue)
AS 市标面积, SUM(Gongcheng.Gc_Jzzj) AS 市标造价
FROM Gongcheng INNER JOIN
zzjg ON Gongcheng.ZzjgID = zzjg.ZzjgID
WHERE (Gongcheng.Gc_Guimo = '面积') AND (Gongcheng.isbiaozhun = '市标')
GROUP BY zzjg.ZzjgID) sb ON dange.ZzjgID = sb.ZzjgID执行时老提示 dange附近有错误
AS 面积, SUM(Gongcheng.Gc_Jzzj) AS 造价
FROM Gongcheng INNER JOIN
zzjg ON Gongcheng.ZzjgID = zzjg.ZzjgID
WHERE (Gongcheng.Gc_Guimo = '面积')
GROUP BY zzjg.ZzjgID, zzjg.Zg_name) dange LEFT OUTER JOIN
(SELECT zzjg.ZzjgID, COUNT(*) AS 市标个数, SUM(Gongcheng.Gc_GuimoValue)
AS 市标面积, SUM(Gongcheng.Gc_Jzzj) AS 市标造价
FROM Gongcheng INNER JOIN
zzjg ON Gongcheng.ZzjgID = zzjg.ZzjgID
WHERE (Gongcheng.Gc_Guimo = '面积') AND (Gongcheng.isbiaozhun = '市标')
GROUP BY zzjg.ZzjgID) sb ON dange.ZzjgID = sb.ZzjgID执行时老提示 dange附近有错误
再子查询一次
AS 面积, SUM(Gongcheng.Gc_Jzzj) AS 造价
FROM Gongcheng INNER JOIN
zzjg ON Gongcheng.ZzjgID = zzjg.ZzjgID
WHERE (Gongcheng.Gc_Guimo = '面积')
GROUP BY zzjg.ZzjgID, zzjg.Zg_name) AS dange LEFT OUTER JOIN (SELECT zzjg.ZzjgID, COUNT(*) AS 市标个数, SUM(Gongcheng.Gc_GuimoValue)
AS 市标面积, SUM(Gongcheng.Gc_Jzzj) AS 市标造价
FROM Gongcheng INNER JOIN
zzjg ON Gongcheng.ZzjgID = zzjg.ZzjgID
WHERE (Gongcheng.Gc_Guimo = '面积') AND (Gongcheng.isbiaozhun = '市标')
GROUP BY zzjg.ZzjgID) sb ON dange.ZzjgID = sb.ZzjgID
select * from (SELECT zzjg.Zg_name, zzjg.ZzjgID, COUNT(*) AS 个数, SUM(Gongcheng.Gc_GuimoValue)
AS 面积, SUM(Gongcheng.Gc_Jzzj) AS 造价
FROM Gongcheng INNER JOIN
zzjg ON Gongcheng.ZzjgID = zzjg.ZzjgID
WHERE (Gongcheng.Gc_Guimo = '面积')
GROUP BY zzjg.ZzjgID, zzjg.Zg_name) dange LEFT OUTER JOIN
(SELECT zzjg.ZzjgID, COUNT(*) AS 市标个数, SUM(Gongcheng.Gc_GuimoValue)
AS 市标面积, SUM(Gongcheng.Gc_Jzzj) AS 市标造价
FROM Gongcheng INNER JOIN
zzjg ON Gongcheng.ZzjgID = zzjg.ZzjgID
WHERE (Gongcheng.Gc_Guimo = '面积') AND (Gongcheng.isbiaozhun = '市标')
GROUP BY zzjg.ZzjgID) sb ON dange.ZzjgID = sb.ZzjgID
??
好像只是一部分吧
AS 面积, SUM(Gongcheng.Gc_Jzzj) AS 造价
FROM Gongcheng INNER JOIN
zzjg ON Gongcheng.ZzjgID = zzjg.ZzjgID
WHERE (Gongcheng.Gc_Guimo = '面积')
GROUP BY zzjg.ZzjgID, zzjg.Zg_name)) dange LEFT OUTER JOIN
(SELECT zzjg.ZzjgID, COUNT(*) AS 市标个数, SUM(Gongcheng.Gc_GuimoValue)
AS 市标面积, SUM(Gongcheng.Gc_Jzzj) AS 市标造价
FROM Gongcheng INNER JOIN
zzjg ON Gongcheng.ZzjgID = zzjg.ZzjgID
WHERE (Gongcheng.Gc_Guimo = '面积') AND (Gongcheng.isbiaozhun = '市标')
GROUP BY zzjg.ZzjgID) sb ON dange.ZzjgID = sb.ZzjgID