select T.CompanyCode, T1.CommonName as CompanyName,Year,Month1Qty,Month2Qty,Month3Qty,Month4Qty,Month5Qty,Month6Qty,Month7Qty,Month8Qty,Month9Qty, Month10Qty,Month11Qty,Month12Qty,
(VALUE(Month1Qty,0)+ VALUE(Month2Qty,0) + VALUE(Month3Qty,0) + VALUE(Month4Qty,0) + VALUE(Month5Qty,0) + VALUE(Month6Qty,0) + VALUE(Month7Qty,0) + VALUE(Month8Qty,0) + VALUE(Month9Qty,0) + VALUE(Month10Qty,0) + VALUE(Month11Qty,0) + VALUE(Month12Qty,0)) AS SUM from RT_ShopTarget as T
LEFT JOIN CM_COMMONCODE as T1 ON T.CompanyCode = T1.CommonCode where T1.CodeType='CC12' and t.Year='2013' order by T.CompanyCode