mrb.
herkese kolay gelsin.
Aşağıdak sorgu ile alınan hizmetlerin aylık toplamlarını alabiliyorum.
Fakat tek sıkıntı her ay toplamının 2 katını veriyor.
size zahmet yardımcı olursanız sevinirim.
SELECT
TANIM.CODE AS 'HİZMET KODU',
TANIM.DEFINITION_ AS 'HİZMET ADI',
TANIM.CARDTYPE AS 'HİZMET TÜRÜ',
OCAK.TOPLAM [OCAK],
SUBAT.TOPLAM [ŞUBAT],
MART.TOPLAM [MART],
NİSAN.TOPLAM [NİSAN],
MAYIS.TOPLAM [MAYIS],
HAZİRAN.TOPLAM [HAZİRAN],
TEMMUZ.TOPLAM [TEMMUZ],
AĞUSTOS.TOPLAM [AĞUSTOS],
EYLÜL.TOPLAM [EYLÜL],
EKİM.TOPLAM [EKİM],
KASIM.TOPLAM [KASIM],
ARALIK.TOPLAM [ARALIK]
from
LG_001_SRVCARD TANIM
LEFT JOIN (SELECT CARDREF, SUM(TOTALS_CASHAMNT) [TOPLAM] FROM LV_001_03_SRVTOT WHERE MONTH_=1 GROUP BY CARDREF ) OCAK ON OCAK.CARDREF =TANIM.LOGICALREF
LEFT JOIN (SELECT CARDREF, SUM(TOTALS_CASHAMNT) [TOPLAM] FROM LV_001_03_SRVTOT WHERE MONTH_=2 GROUP BY CARDREF ) SUBAT ON SUBAT.CARDREF =TANIM.LOGICALREF
LEFT JOIN (SELECT CARDREF, SUM(TOTALS_CASHAMNT) [TOPLAM] FROM LV_001_03_SRVTOT WHERE MONTH_=3 GROUP BY CARDREF ) MART ON MART.CARDREF =TANIM.LOGICALREF
LEFT JOIN (SELECT CARDREF, SUM(TOTALS_CASHAMNT) [TOPLAM] FROM LV_001_03_SRVTOT WHERE MONTH_=4 GROUP BY CARDREF ) NİSAN ON NİSAN.CARDREF =TANIM.LOGICALREF
LEFT JOIN (SELECT CARDREF, SUM(TOTALS_CASHAMNT) [TOPLAM] FROM LV_001_03_SRVTOT WHERE MONTH_=5 GROUP BY CARDREF ) MAYIS ON MAYIS.CARDREF =TANIM.LOGICALREF
LEFT JOIN (SELECT CARDREF, SUM(TOTALS_CASHAMNT) [TOPLAM] FROM LV_001_03_SRVTOT WHERE MONTH_=6 GROUP BY CARDREF ) HAZİRAN ON HAZİRAN.CARDREF =TANIM.LOGICALREF
LEFT JOIN (SELECT CARDREF, SUM(TOTALS_CASHAMNT) [TOPLAM] FROM LV_001_03_SRVTOT WHERE MONTH_=7 GROUP BY CARDREF ) TEMMUZ ON TEMMUZ.CARDREF =TANIM.LOGICALREF
LEFT JOIN (SELECT CARDREF, SUM(TOTALS_CASHAMNT) [TOPLAM] FROM LV_001_03_SRVTOT WHERE MONTH_=8 GROUP BY CARDREF ) AĞUSTOS ON AĞUSTOS.CARDREF =TANIM.LOGICALREF
LEFT JOIN (SELECT CARDREF, SUM(TOTALS_CASHAMNT) [TOPLAM] FROM LV_001_03_SRVTOT WHERE MONTH_=9 GROUP BY CARDREF ) EYLÜL ON EYLÜL.CARDREF =TANIM.LOGICALREF
LEFT JOIN (SELECT CARDREF, SUM(TOTALS_CASHAMNT) [TOPLAM] FROM LV_001_03_SRVTOT WHERE MONTH_=10 GROUP BY CARDREF ) EKİM ON EKİM.CARDREF =TANIM.LOGICALREF
LEFT JOIN (SELECT CARDREF, SUM(TOTALS_CASHAMNT) [TOPLAM] FROM LV_001_03_SRVTOT WHERE MONTH_=11 GROUP BY CARDREF ) KASIM ON KASIM.CARDREF =TANIM.LOGICALREF
LEFT JOIN (SELECT CARDREF, SUM(TOTALS_CASHAMNT) [TOPLAM] FROM LV_001_03_SRVTOT WHERE MONTH_=12 GROUP BY CARDREF ) ARALIK ON ARALIK.CARDREF =TANIM.LOGICALREF
WHERE TANIM.CODE LIKE ('00%')