Update (SQL) - Wikipedia, the free encyclopedia

UPDATE T1 SET C1 = 2 WHERE C2 IN ( SELECT C3 FROM T2 WHERE C4 = 0). One may also update multiple ...

en.m.wikipedia.org