CREATE VIEW dbo.CARI_HAREKETLER
AS
SELECT        *
FROM            ((SELECT        [BA], [FICHENO], [FIS_TURU], [DEFINITION_], [DATE_], [AMOUNT], [GENEXP], [KULLANICI],CANCELLED
                            FROM            [IHR].[dbo].[CARI_FISI_LISTESI])
                         UNION ALL
                         (SELECT        [BA], [FICHENO], [FIS_TURU], [DEFINITION_], [DATE_], [TOPLAM] AS AMOUNT, [GENEXP], [KULLANICI],CANCELLED
                          FROM            [IHR].[dbo].[FIRMAYA_GORE_FIS_TOPLAMLARI])) QQ