Banka Borç Alacak Durumu
SELECT A.NETHESKODU, B.ACIKLAMA, SUM( CASE WHEN BA='B' THEN A.TUTAR ELSE 0 END) BORC, SUM( CASE WHEN BA='A' THEN A.TUTAR ELSE 0 END) ALACAK, (CASE WHEN ( SUM( CASE WHEN BA='B' THEN A.TUTAR ELSE 0 END) - SUM( CASE WHEN BA='A' THEN A.TUTAR ELSE 0 END) )> 0 THEN (SUM( CASE WHEN BA='B' THEN A.TUTAR ELSE 0 END) - SUM( CASE WHEN BA='A' THEN A.TUTAR ELSE 0 END)) ELSE 0 END) BORC_BAK, (CASE WHEN ( SUM( CASE WHEN BA='B' THEN A.TUTAR ELSE 0 END) - SUM( CASE WHEN BA='A' THEN A.TUTAR ELSE 0 END)) < 0 THEN ( SUM( CASE WHEN BA='B' THEN A.TUTAR ELSE 0 END) - SUM( CASE WHEN BA='A' THEN A.TUTAR ELSE 0 END)) ELSE 0 END) ALAC_BAK FROM TBLBNKHESTRA A LEFT OUTER JOIN TBLBNKHESSABIT B ON (A.NETHESKODU=B.NETHESKODU) WHERE B.HESAPTIPI=0 AND TARIH BETWEEN 'İLK TARİH' AND 'SON TARİH' GROUP BY A.NETHESKODU,B.ACIKLAMA ORDER BY A.NETHESKODU ASC
Uyarlama için: