View: dbo.Taxing_Authority_View
View definition
create view dbo.Taxing_Authority_View
as
select
taxing_authority_KEY = TAU.taxing_authority_KEY
, description = TAU.description
, rate = TAU.rate
, taxing_authority_type_KEY = TAU.taxing_authority_type_KEY
, taxing_authority_type__description = TAT.description
, apply_to_shipping = TAU.apply_to_shipping
, apply_to_discount = TAU.apply_to_discount
from
dbo.Taxing_Authority TAU
left outer join
dbo.Taxing_Authority_Type TAT on TAT.taxing_authority_type_KEY = TAU.taxing_authority_type_KEY