View: dbo.Withdrawal_Bank_Transaction_Full_View | |||
View definition | |||
CREATE VIEW dbo.Withdrawal_Bank_Transaction_Full_View AS SELECT bank_transaction_KEY = BT.bank_transaction_KEY , transaction_date = BT.transaction_date , bank_transaction_type_KEY = BT.bank_transaction_type_KEY , checkbook_KEY = BT.checkbook_KEY , transaction_status_KEY = BT.transaction_status_KEY , amount = BT.amount , reference_number = BT.reference_number , memo = BT.memo , description = BT.description , is_handwritten_check = BT.is_handwritten_check , address_1 = COALESCE(A.address_1, N'') , address_2 = COALESCE(A.address_2, N'') , city = COALESCE(A.city, N'') , state_abbreviation = COALESCE(A.state_abbreviation, N'') , postal_code = COALESCE(A.postal_code, N'') , county = COALESCE(A.county, N'') , country = COALESCE(A.country, N'') FROM dbo.Bank_Transaction BT LEFT JOIN dbo.Bank_Transaction_Address BTA ON BTA.bank_transaction_KEY = BT.bank_transaction_KEY LEFT JOIN dbo.Address A ON A.address_KEY = BTA.address_KEY WHERE bank_transaction_type_KEY in (1,3,5) | |||