8 lines
341 B
SQL
8 lines
341 B
SQL
--Migration
|
|
UPDATE onf
|
|
SET C_ESLKOZEPESATLAG = 2.5
|
|
FROM T_OKTATASINEVELESIFELADAT onf
|
|
INNER JOIN T_TANEV tv ON tv.ID = onf.C_ALTANEVID AND tv.TOROLT = 'F'
|
|
INNER JOIN T_INTEZMENY i ON i.ID = onf.C_ALINTEZMENYID AND i.TOROLT = 'F'
|
|
WHERE onf.ID IN (1160, 1161, 1162, 5435, 1176, 6463, 7664, 7760, 7764, 7765, 7766, 7894, 7895, 7896)
|
|
|