11 lines
311 B
SQL
11 lines
311 B
SQL
UPDATE tcs
|
|
SET tcs.C_BELEPESDATUM = '20180901'
|
|
FROM T_TANULOCSOPORT tcs
|
|
INNER JOIN T_TANEV te ON te.ID = tcs.C_TANEVID
|
|
INNER JOIN T_INTEZMENY i ON i.ID = te.C_INTEZMENYID
|
|
WHERE te.C_NEV = '2018/2019'
|
|
AND te.TOROLT = 'F'
|
|
AND i.TOROLT = 'F'
|
|
AND tcs.TOROLT = 'F'
|
|
AND tcs.C_BELEPESDATUM = '20180903'
|