SELECT TCNO_VERGINO
,CARI_ACIKLAMA
,ULKESI
,AY
,ADET
,KDV_HARIC_TOPLAM
,BA_BS
FROM WEB_BABS WHERE TCNO_VERGINO='2960415825' AND BA_BS='BA'
UNION ALL SELECT 'TOPLAM','','',NULL,NULL,SUM(KDV_HARIC_TOPLAM),''
FROM WEB_BABS WHERE TCNO_VERGINO='2960415825' AND BA_BS='BA'
GROUP BY BA_BS ,TCNO_VERGINO ORDER BY TCNO_VERGINO,AY
Hiç yorum yok:
Yorum Gönder