I am getting thsi below error and would appreciate if someone guide me on how to fix it.
UPDATE LKP_TBL FROM
SET TestId = MAX(STG.TestId)
--E--line 241-- SPL1027:E(L241), Missing/Invalid SQL statement'E(3872):Illegal use of an aggregate operation in an UPDATE statement.'.
This is no Teradata syntax, seems to be SQL Server (and should also fail there).
SET TestId = (SELECT MAX(TestId) FROM st_TEST_LIVE_UF)