9 lines
189 B
Transact-SQL
9 lines
189 B
Transact-SQL
UPDATE T_OSZTALY SET
|
|
C_GIMNAZIUMIEVFOLYAMTIPUSID = (SELECT DISTINCT ID
|
|
FROM T_DICTIONARYITEMBASE
|
|
WHERE C_TYPE = 'GimnaziumiEvfolyamTipus'
|
|
AND C_NAME = 'Na'
|
|
AND TOROLT = 'F')
|
|
|
|
GO
|