SELECT
distinct P.id_posgrado,P.nombre,a.nombre
FROM posgrado P
INNER JOIN areas_conocimiento a
on a.id_areaconocimiento=P.id_areaconocimiento
WHERE P.id_posgrado IN (1163814)
SELECT programa
FROM UNISOFT4.VIEWPORASIGNATURASOFERTADAS WHERE
programa in (1163814)
and modalidad = 'VC'
AND (LUNES IS NOT NULL
OR MARTES IS NOT NULL
OR MIERCOLES IS NOT NULL
OR JUEVES IS NOT NULL
OR VIERNES IS NOT NULL
OR SABADO IS NOT NULL)
and modalidad = 'VC'
group by programa
having count(*)>0
