-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- View: vw_insc_subcomision
-- Version: 3.0.0
-- Inscripciones a subcomisiones. 
-- Recupera inscripciones de la tabla real y la histórica
-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

-- DROP VIEW vw_insc_subcomision;
CREATE OR REPLACE VIEW vw_insc_subcomision
(
   inscripcion,
   subcomision
)
AS 
 SELECT 
   inscripcion,
   subcomision
 FROM 
    sga_insc_subcomision

UNION ALL 

 SELECT 
   inscripcion,
   subcomision
 FROM 
    his_insc_subcomision
;
 
 -- ++++++++++++++++++++++++++++++ Fin view vw_insc_subcomision +++++++++++++++++++++++++++++++++++++++

GRANT SELECT ON vw_insc_subcomision to public;