Very appriciate if you can help. my script as below.
SET SHOWPLAN_ALL OFF
GO
SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING,ANSI_WARNINGS,CONCAT_NULL_YIELDS_NULL ON
GO
SET ARITHABORT,QUOTED_IDENTIFIER,ANSI_NULLS ON
GO
DROP VIEW VW_wanted
GO
CREATE VIEW VW_wanted
WITH SCHEMABINDING
AS
select t1.wanted_id ,
t1.local_warrant_arrest_no ,
t4.offence_id ,
t4.police_report_number,...