SQL数据库语句问题

黑灬Black

语法有问题

ming_xu

看不懂，学习中

huzi5182000

drop table jf_sa_fahuobiao
create table jf_sa_fahuobiao (cCuscode  VARCHAR(20), cCusName VARCHAR(98),isum  money,qc money)
Insert into jf_sa_fahuobiao (ccuscode,cCusName,isum,qc)
select x.cCuscode  ,max(x.cCusName ),sum(x.isum  ) from (
select DispatchList.cCuscode as cCuscode  ,DispatchList.cCusName cCusName, DispatchLists.isum as isum  from DispatchList right JOIN DispatchLists on DispatchList.DLID = DispatchLists.DLID WHERE (dDate >= CONVERT(DATETIME, '2009-11-17 00:00:00', 102)) and (dDate <= CONVERT(DATETIME, '2010-04-17 00:00:00', 102))
) x group  x.cCuscode  

huzi5182000

drop table jf_sa_fahuobiao
create table jf_sa_fahuobiao (cCuscode  VARCHAR(20), cCusName VARCHAR(98),isum  money,qc money)
Insert into jf_sa_fahuobiao (ccuscode,cCusName,isum,qc)
select x.cCuscode  ,max(x.cCusName ),sum(x.isum  ) from (
select DispatchList.cCuscode as cCuscode  ,DispatchList.cCusName cCusName, DispatchLists.isum as isum  from DispatchList right JOIN DispatchLists on DispatchList.DLID = DispatchLists.DLID WHERE (dDate >= CONVERT(DATETIME, '2009-11-17 00:00:00', 102)) and (dDate <= CONVERT(DATETIME, '2010-04-17 00:00:00', 102))
) x group  x.cCuscode  

mawenjun0504

你写的语句比较混乱，下面是我整理好的语句，你看看
create table jf_sa_fahuobiao (cCuscode  VARCHAR(20), cCusName VARCHAR(98),isum  money,qc money)
Insert into jf_sa_fahuobiao (ccuscode,cCusName,isum,qc)
select DispatchList.cCuscode,DispatchList.cCusName, sum(DispatchLists.isum) isum,a.isum qc
from DispatchList
right JOIN DispatchLists on DispatchList.DLID = DispatchLists.DLID
inner join (select  sum(DispatchLists.isum) isum,ccuscode from DispatchList right JOIN DispatchLists on DispatchList.DLID = DispatchLists.DLID
       WHERE (dDate < CONVERT(DATETIME, '2009-11-17 00:00:00', 102))  and DispatchList.ccusname is not null
       GROUP BY ccuscode ) a on DispatchList.ccuscode = a.ccuscode

WHERE (dDate >= CONVERT(DATETIME, '2009-11-17 00:00:00', 102)) and (dDate <= CONVERT(DATETIME, '2010-04-17 00:00:00', 102))
and DispatchList.ccusname is not null
GROUP BY DispatchList.ccuscode,DispatchList.cCusName,a.isum

ˊｘ.____Ｑ.

还是没有看懂 哎

498098148

来学习学习，请多多关照