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 | |||