核对。4.3将用水分类数量与其单价进行汇总核对。 供参考的类SQL描述有:SelectSUM([HJJE]),SUM([JE1]+[JE2]+[JE3]+[JE4]+[JE5])AS合计金额From[业务_RateHistory]SelectSUM([JE12]+[JE22]+[JE32]+[JE42]+[JE52])AS附加,SUM([JE13]+[JE23]+[JE33]+[JE43]+[JE53])AS污水费,SUM([JE14]+[JE24]+[JE34]+[JE44]+[JE54])AS水资业务费,SUM([DSHJJE])AS代收费合计From[业务_RateHistory]Select[业务_RateHistory].[ID],[业务_RateHistory].[MeterID],[业务_RateHistory].[CurMonth],[业务_RateHistory].[PriceID],[业务_RateHistory].[SL1],[业务_RateHistory].[JE1],[业务_Price].[Price1],[业务_Price].[Addit1],[业务_Price].[Addit2],[业务_Price].[Addit3]INTO数量套单价合并表11From[业务_RateHistory]LEFTJoin[业务_Price]On[业务_RateHistory].[PriceID]=[业务_Price].[ID]Select[ID],[MeterID],[CurMonth],[JE1],[SL1]*[Price1]AS基本单价,[SL1]*[Addit1]AS城市附加费,[SL1]*[Addit2]AS污水处理费,[SL1]*[Addit3]AS水资业务费INTO数量套单价合并表12From[数量套单价合并表11] 五、步骤五5.核对实收金额的正确性
全文预览
