原本的sql语句如下:
SELECT
distinct
SR1SRCD,SR1TRDT,SR1DPNO,SR2DGNO
,(SR2STRK+SR2STRK2+SR2TAX) as SR2_KINGAKU,
(SR1STRK+SR1STRK2+SR1TAX) as SR1_KINGAKU
FROM SASR_TT_SR1,SASR_TT_SR2,SAZI_TM_PRI ,SAMT_TM_TRI
WHERE SR1DPNO = SR2DPNO
AND (SR2PRCD = PRIPRCD AND SR2MJCD = PRIMJCD )
AND (SR1SRCD = TRITRCD AND SR1MJCD =TRIMJCD)
AND SR1MJCD = '2779999999'
AND SR1TRDT >='2008/09/01'
AND SR1TRDT <='2008/09/30'AND (SR1UPK7='0' or SR1UPK7= '')
order by SR1SRCD,SR1TRDT,SR1DPNO,SR2DGNO
查询出来的结果如图显示:
sr1dpno sr2dgno sr2_kingaku sr1_kingaku
00006 1 26250 26250
00043 1 1000 152250
00043 2 102900 152250我现在要求SR1_KINGAKU的和
应该怎么样写才能在求和的时候不会把重复的SR1DPNO的SR1_KINGAKU的値重复相加多次
SELECT
distinct
SR1SRCD,SR1TRDT,SR1DPNO,SR2DGNO
,(SR2STRK+SR2STRK2+SR2TAX) as SR2_KINGAKU,
(SR1STRK+SR1STRK2+SR1TAX) as SR1_KINGAKU
FROM SASR_TT_SR1,SASR_TT_SR2,SAZI_TM_PRI ,SAMT_TM_TRI
WHERE SR1DPNO = SR2DPNO
AND (SR2PRCD = PRIPRCD AND SR2MJCD = PRIMJCD )
AND (SR1SRCD = TRITRCD AND SR1MJCD =TRIMJCD)
AND SR1MJCD = '2779999999'
AND SR1TRDT >='2008/09/01'
AND SR1TRDT <='2008/09/30'AND (SR1UPK7='0' or SR1UPK7= '')
order by SR1SRCD,SR1TRDT,SR1DPNO,SR2DGNO
查询出来的结果如图显示:
sr1dpno sr2dgno sr2_kingaku sr1_kingaku
00006 1 26250 26250
00043 1 1000 152250
00043 2 102900 152250我现在要求SR1_KINGAKU的和
应该怎么样写才能在求和的时候不会把重复的SR1DPNO的SR1_KINGAKU的値重复相加多次
请哪位了解或许知道是告诉我一下吧