The following UPDATE request updates the NoPI table nopi012_t1 aliased as t1.
UPDATE t1 FROM nopi012_t1 AS t1, nopi012_t2 AS t2 SET c3 = t1.c3 * 1.05 WHERE t1.c2 = t2.c2;
The following UPDATE request updates the NoPI table nopi012_t1 aliased as t1.
UPDATE t1 FROM nopi012_t1 AS t1, nopi012_t2 AS t2 SET c3 = t1.c3 * 1.05 WHERE t1.c2 = t2.c2;