摘要:
1 原始语句SELECT C.ParentId,A.Area_DM, A.Airport_DM, (' ' + B.QC) AS AirportName,Sum(JCN) AS TotalJCN,SUM(CR + ET + CRWH + ETWH) AS TotalLK,Sum(HW + YJ) AS TotalHY, Sort = 1FROM AirportProduces_2006 ALEFT JOIN Airports B ON A.Airport_DM = B.Airport_DMLEFT JOIN Areas AS C ON C.Area_DM = A.Area_DM 阅读全文