View: core.industry_scrud_view

Schema	core
Materialized View Name	industry_scrud_view
Owner	postgres
Tablespace	DEFAULT
Description

 CREATE OR REPLACE VIEW core.industry_scrud_view
 AS
 SELECT industries.industry_id,
    industries.industry_name,
    parent_industry.industry_name AS parent_industry_name
   FROM core.industries
   LEFT JOIN core.industries parent_industry ON industries.parent_industry_id = parent_industry.industry_id;