11 lines
361 B
SQL
11 lines
361 B
SQL
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' |