View: dbo.Checkbook_View
View definition
create view dbo.Checkbook_View
as
select CB.*
, bank__contact_KEY = B.contact_KEY
, checkbook__active_status_KEY = CASE WHEN CB.is_account_inactive = 0 THEN 1 ELSE 2 END -- Column added to match with the Active_Status View for Status Filter
from
dbo.Checkbook AS CB
left outer join
dbo.Bank AS B
on
CB.bank_KEY = B.bank_KEY