2009年2月25日
一个SQL语句的变化过程
摘要： 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 阅读全文
posted @ 2009-02-25 10:58 大侠酷裤马路 阅读(242) 评论(0) 推荐(0)