CREATE VIEW dbo.vw_Categories
WITH SCHEMABINDING
SELECT dbo.tscw.webcat_id               AS firstcatid,
       dbo.tscw.webcat_category_name    AS firstcatname,
       dbo.tscw.webcat_intro_text       AS firstcatintrotext,
       dbo.tscw.webcat_materials        AS firstcatmaterials,
       dbo.tscw.webcat_capacities       AS firstcatcapacities,
       dbo.tscw.webcat_finishes         AS firstcatfinishes,
       dbo.tscw.webcat_applications     AS firstcatapplications,
       dbo.tscw.webcat_printing_options AS firstcatprintopt,
       dbo.tscw.webcat_group_image      AS firstcatgroupimage,
       dbo.tscw.webcat_brief            AS firstcatbrief,
       dbo.tscw.webcat_sequence         AS firstcatsequence,
       dbo.tscw.webcat_fact_sheet_file  AS firstcatfactsheetfile,
       dbo.tscs.webcats_id              AS secondcatid,
       dbo.tscs.webcats_category_name   AS secondcatname,
       dbo.tscs.webcats_intro_text      AS secondcatintrotext,
       dbo.tscs.webcats_group_image     AS secondcatgroupimage,
       dbo.tscs.webcats_brief           AS secondcatbrief,
       dbo.tscs.webcats_sequence        AS secondcatsequence,
       dbo.tscs.webcats_fact_sheet_file AS secondcatfactsheetfile,
       dbo.tsct.webcatt_id              AS thirdcatid,
       dbo.tsct.webcatt_category_name   AS thirdcatname,
       dbo.tsct.webcatt_intro_text      AS thirdcatintrotext,
       dbo.tsct.webcatt_group_image     AS thirdcatgroupimage,
       dbo.tsct.webcatt_brief           AS thirdcatbrief,
       dbo.tsct.webcatt_sequence        AS thirdcatsequence,
       dbo.tsct.webcatt_fact_sheet_file AS thirdcatfactsheetfile
FROM   dbo.tscw
INNER JOIN dbo.ts_custom_form_link AS primseclink
 ON dbo.tscw.webcat_id = primseclink.cfln_parent_form_id
    AND primseclink.cfln_parent_form_type_code = 'cf_webcat'
INNER JOIN dbo.tscs
 ON primseclink.cfln_child_form_type_code = 'cf_secondcats'
    AND primseclink.cfln_child_form_id = dbo.tscs.webcats_id
LEFT OUTER JOIN dbo.ts_custom_form_link AS sectertlink
 ON dbo.tscs.webcats_id = sectertlink.cfln_parent_form_id
    AND sectertlink.cfln_parent_form_type_code = 'cf_secondcats'
LEFT OUTER JOIN dbo.tsct
 ON sectertlink.cfln_child_form_type_code = 'cf_thirdcats'
    AND sectertlink.cfln_child_form_id = dbo.tsct.webcatt_id  
    
CREATE UNIQUE CLUSTERED INDEX IDX_??
    ON vw_Categories (??);
GO