TRY SELECT X.RQ, Y.ZCS,Y.FSD,X.WC,X.SDS FROM ( select MONTH(X.RQ) as RQ,SUM(X.WC) WC,SUM(X.SDS) SDS FROM 表1 WHERE RQ BETWEEN '2010-1-1' AND '2010-12-31' AND FZ='x' GROUP BY MONTH(X.RQ) ) X INNER JOIN 表2 Y ON X.FZ=Y.FZ
修正 SELECT DISTINCT X.RQ, Y.ZCS,Y.FSD,X.WC,X.SDS FROM ( select MONTH(X.RQ) as RQ,FZ,SUM(X.WC) WC,SUM(X.SDS) SDS FROM 表1 WHERE RQ BETWEEN '2010-1-1' AND '2010-12-31' AND FZ='x' GROUP BY MONTH(X.RQ),FZ ) X INNER JOIN 表2 Y ON X.FZ=Y.FZ
SELECT X.RQ, Y.ZCS,Y.FSD,X.WC,X.SDS
FROM (
select MONTH(X.RQ) as RQ,SUM(X.WC) WC,SUM(X.SDS) SDS
FROM 表1
WHERE RQ BETWEEN '2010-1-1' AND '2010-12-31' AND FZ='x'
GROUP BY MONTH(X.RQ)
) X
INNER JOIN 表2 Y ON X.FZ=Y.FZ
SELECT DISTINCT X.RQ, Y.ZCS,Y.FSD,X.WC,X.SDS
FROM (
select MONTH(X.RQ) as RQ,FZ,SUM(X.WC) WC,SUM(X.SDS) SDS
FROM 表1
WHERE RQ BETWEEN '2010-1-1' AND '2010-12-31' AND FZ='x'
GROUP BY MONTH(X.RQ),FZ
) X
INNER JOIN 表2 Y ON X.FZ=Y.FZ