6 lines
No EOL
195 B
SQL
6 lines
No EOL
195 B
SQL
update oo
|
|
set oo.C_FOGLALKOZASID = NULL
|
|
from T_ORARENDIORA oo
|
|
inner join T_FOGLALKOZAS f on f.ID = oo.C_FOGLALKOZASID and f.TOROLT = 'F'
|
|
where oo.TOROLT = 'F'
|
|
and oo.C_TANARID <> f.C_TANARID |