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 );






posted @ 2015-10-28 12:03  月渊  阅读(4309)  评论(0)  编辑  收藏  举报