摘要:
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 阅读全文