﻿UPDATE oo
SET
	C_ORASZAM = csro.C_ORASZAM
	,C_ORAKEZDETE = csro.C_KEZDETE
	,C_ORAVEGE = csro.C_VEGE
	,C_CSENGETESIRENDID = csro.C_CSENGETESIRENDID
FROM T_ORARENDIORA oo
JOIN T_CSENGETESIRENDORA csro ON
	csro.ID = oo.C_CSENGETESIRENDORAID AND csro.C_INTEZMENYID = oo.C_INTEZMENYID AND csro.C_TANEVID = oo.C_TANEVID AND csro.TOROLT = 'F'
WHERE
	oo.TOROLT = 'F'