Kod: Tümünü seç
SELECT CS.CARI_KOD,CS.CARI_ISIM,SUM(ALACAK-BORC) AS BAKIYE,
(SELECT SUM(ALACAK) FROM TBLCAHAR WITH (NOLOCK) WHERE CARI_KOD=CH.CARI_KOD AND HAREKET_TURU='G') AS CEK_TOPLAM,
(SELECT EFF_SATIS FROM NETSIS..DOVIZ WITH (NOLOCK) WHERE CONVERT(VARCHAR, GETDATE(),23)=TARIH AND SIRA='1') AS GUNLUK_KUR,
(SELECT SUM(ALACAK) FROM TBLCAHAR WITH (NOLOCK) WHERE CARI_KOD=CH.CARI_KOD AND HAREKET_TURU='G')/
(SELECT EFF_SATIS FROM NETSIS..DOVIZ WITH (NOLOCK) WHERE CONVERT(VARCHAR, GETDATE(),23)=TARIH AND SIRA='1') AS DOVIZLI_TOPLAM,
(SELECT SUM(ALACAK) FROM TBLCAHAR WITH (NOLOCK) WHERE CARI_KOD=CH.CARI_KOD AND HAREKET_TURU='G')/
(SELECT EFF_SATIS FROM NETSIS..DOVIZ WITH (NOLOCK) WHERE CONVERT(VARCHAR, GETDATE(),23)=TARIH AND SIRA='1')-
(SELECT CS.CARI_KOD,CS.CARI_ISIM,SUM(ALACAK-BORC)) AS KALAN_TOPLAM
FROM TBLCAHAR CH
WITH (NOLOCK) INNER JOIN TBLCASABIT CS
WITH (NOLOCK) ON CS.CARI_KOD=CH.CARI_KOD
WHERE CH.CARI_KOD='120 614'
GROUP BY CH.CARI_KOD,CARI_ISIM,BAKIYE,CS.CARI_KOD
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.