UPDATE TB_HISTORICO SET 
​
HIS_MINFAL_TEO = (select SUM(CAU_MINUTOS) from TB_MESTRE_DISCIPLINA
inner join TB_TURMA_DISCIP on TDI_TURDISID = MDI_TURDISID
inner join TB_TURMA on TUR_ID = TDI_TURID
inner join TB_REGISTRO_FALTAS on RFA_MDIID = MDI_ID
inner join TB_CRONOGRAMA_AULA on CAU_ID = RFA_CAUID
inner join TB_CRONOGRAMA_AULA_DATA on CAD_ID = CAU_CADID
where MDI_ID = HIS_MDIID
and CAU_TIPAUL = 'TEORICA'
and (SELECT count(*) FROM
dbo.FUNC_GET_PERIODOS(tdi_turdisid,
HIS_TNPID, 1, CAD_DATA, CAD_DATA, 0)) > 0),
​
HIS_MINFAL_PRA = (select SUM(CAU_MINUTOS) from TB_MESTRE_DISCIPLINA
inner join TB_TURMA_DISCIP on TDI_TURDISID = MDI_TURDISID
inner join TB_TURMA on TUR_ID = TDI_TURID
inner join TB_REGISTRO_FALTAS on RFA_MDIID = MDI_ID
inner join TB_CRONOGRAMA_AULA on CAU_ID = RFA_CAUID
inner join TB_CRONOGRAMA_AULA_DATA on CAD_ID = CAU_CADID
where MDI_ID = HIS_MDIID
and CAU_TIPAUL = 'PRATICA'
and (SELECT count(*) FROM
dbo.FUNC_GET_PERIODOS(tdi_turdisid,
HIS_TNPID, 1, CAD_DATA, CAD_DATA, 0)) > 0),
​
HIS_MINFAL_COMP_TEO = (select SUM(CAU_MINUTOS) from TB_MESTRE_DISCIPLINA
inner join TB_TURMA_DISCIP on TDI_TURDISID = MDI_TURDISID
inner join TB_TURMA on TUR_ID = TDI_TURID
inner join TB_REGISTRO_FALTAS on RFA_MDIID = MDI_ID
inner join TB_CRONOGRAMA_AULA on CAU_ID = RFA_CAUID
inner join TB_CRONOGRAMA_AULA_DATA on CAD_ID = CAU_CADID
where MDI_ID = HIS_MDIID
and CAU_TIPAUL = 'TEORICA'
and RFA_FALABO = 1
and (SELECT count(*) FROM
dbo.FUNC_GET_PERIODOS(tdi_turdisid,
HIS_TNPID, 1, CAD_DATA, CAD_DATA, 0)) > 0),
​
HIS_MINFAL_COMP_PRA = (select SUM(CAU_MINUTOS) from TB_MESTRE_DISCIPLINA
inner join TB_TURMA_DISCIP on TDI_TURDISID = MDI_TURDISID
inner join TB_TURMA on TUR_ID = TDI_TURID
inner join TB_REGISTRO_FALTAS on RFA_MDIID = MDI_ID
inner join TB_CRONOGRAMA_AULA on CAU_ID = RFA_CAUID
inner join TB_CRONOGRAMA_AULA_DATA on CAD_ID = CAU_CADID
where MDI_ID = HIS_MDIID
and CAU_TIPAUL = 'PRATICA'
and RFA_FALABO = 1
and (SELECT count(*) FROM
dbo.FUNC_GET_PERIODOS(tdi_turdisid,
HIS_TNPID, 1, CAD_DATA, CAD_DATA, 0)) > 0)
​
WHERE HIS_ID IN (select his_id from tb_historico
	inner join TB_PADDIS_TIPNOT on TNP_ID = HIS_TNPID
		inner join TB_PADRONIZACAO_DIS on PDI_ID = TNP_PDIID
where HIS_FALTA is not null and HIS_FALTA > 0 
and PDI_FORDIGFRE = 'FALDATHOR'
and HIS_MDIID in 
(select RFA_MDIID from TB_REGISTRO_FALTAS))