34,593
社区成员
发帖
与我相关
我的任务
分享
1.可以将 SUM(SUM(DT_Park.MNP)+SUM(DT_Park.ANP)) SMNP 改为SUM(DT_Park.MNP)+SUM(DT_Park.ANP) as SMNP
2.必须将sql += "group by DT_Area.ID , DT_Area.Aname";改为sql += " group by DT_Area.ID , DT_Area.Aname"; group前加空格,不然拼接的sql是有误的。
sql += "where DT_Area.ID = DT_Park.AID";
sql += " group by DT_Area.ID , DT_Area.Aname";
[/quote]这个by问题解决了
sql += "where DT_Area.ID = DT_Park.AID";
sql += " group by DT_Area.ID , DT_Area.Aname";
// LZ 的语句没有问题,只是你少写了一个空格
// 在 group by 前加一个空格,你这样拼接出来语句,变成 AIDgroup by ,应该是AID group by
sql += "where DT_Area.ID = DT_Park.AID";
sql += "group by DT_Area.ID , DT_Area.Aname";
select DT_Area.ID, DT_Area.Aname, SUM(DT_Park.MNP+DT_Park.ANP) as SMNP,
SUM(DT_Park.CNP) SCNP from DT_Area , DT_Park
where DT_Area.ID = DT_Park.AID
group by DT_Area.ID , DT_Area.Aname
SUM(SUM(DT_Park.MNP)+SUM(DT_Park.ANP)) SMNP
改為:
SUM(DT_Park.MNP+DT_Park.ANP) SMNP