sqlite两表更新update

1 2 3 4 5 6 7 8 9 10 11 12

UPDATE t1 SET Column1 =   ( SELECT Columnx    FROM t2    WHERE t2. KEY = t1. KEY ), Column2 =   ( SELECT Columny    FROM t2    WHERE t2. KEY = t1. KEY ), WHERE t1. KEY =     ( SELECT KEY      FROM t2      WHERE t2. KEY = t1. KEY );

来自为知笔记(Wiz)