Firebird
0
Вклад в тег
UPDATE TABLE_A
SET "VALUE" = "VALUE" + CASE
WHEN EXISTS(SELECT * FROM TABLE_B WHERE TABLE_B."VALUE" = TABLE_A."VALUE")
THEN + 1
ELSE + 2
END
