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