就象楼主的写法挺好啊。
改为JOIN:
insert into %s
select A.JcNo, B.QdName, C.CcKindName, Sum(A.Distance) as Distance,
Sum(A.Degree) as Degree, sum(A.Wdistance) as WDistance,
Sum(A.Power) as Power
from %s as A
join %s as B on A.QdNo=B.QdNo
join %s as C on A.CcKind=C.CcKindNo
--where A.QdNo=B.QdNo and A.CcKind=C.CcKindNo
group by A.JcNo,B.QdName,C.CcKindName
order by A.JcNo ASC, B.QdName ASC, C.CcKindName ASC
改为JOIN:
insert into %s
select A.JcNo, B.QdName, C.CcKindName, Sum(A.Distance) as Distance,
Sum(A.Degree) as Degree, sum(A.Wdistance) as WDistance,
Sum(A.Power) as Power
from %s as A
join %s as B on A.QdNo=B.QdNo
join %s as C on A.CcKind=C.CcKindNo
--where A.QdNo=B.QdNo and A.CcKind=C.CcKindNo
group by A.JcNo,B.QdName,C.CcKindName
order by A.JcNo ASC, B.QdName ASC, C.CcKindName ASC
,qdname=(select qdname from %s where QdNo=a.QdNo)
,CcKindName=(select qdname from %s where CcKind=a.CcKind)
,Sum(A.Distance) as Distance
,Sum(A.Degree) as Degree
,sum(A.Wdistance) as WDistance
,Sum(A.[Power]) as [Power ]
from %s a
group by jcno,qdname,CcKindName
order by JcNo,QdName,CcKindName
不知道邹建大哥的写法效率如何?
我是认为嵌套的SQL效率最高,你意见如何?