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)