CREATE VIEW dbo.KASA_BAKIYELERI
AS
SELECT        QQ.DEFINITION_, SUM(BORC) - SUM(ALACAK) AS BAKIYE
FROM            ((SELECT        DEFINITION_, SUM(AMOUNT) AS ALACAK, 0 AS BORC
                            FROM            [IHR].[dbo].[KASA_HAREKETLERI]
                            WHERE        CANCELLED = 0 AND BA = 'ALACAK'
                            GROUP BY DEFINITION_)
                         UNION ALL
                         (SELECT        DEFINITION_, 0 AS ALACAK, SUM(AMOUNT) AS BORC
                          FROM            [IHR].[dbo].[KASA_HAREKETLERI]
                          WHERE        CANCELLED = 0 AND BA = 'BORÇ'
                          GROUP BY DEFINITION_)) QQ
GROUP BY QQ.DEFINITION_