SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
create view [dbo].[vw_act_others]
as

select *
from act_actors
	inner join adr_addresses on act_address_id = adr_address_id
where act_type_code not in ('BNK','BRA','CIE','CLI','INT')
GO
