2012/3/14, FengTao DING <hwk...@motorola.com>: > Because in my UPDATE case, the new values that will be updated come from > another different table, and the UPDATE's WHERE condition also involves > columns from more than one tables(actually 3),
UPDATE tab1 SET val1=(SELECT val2 FROM tab2 WHERE ...) WHERE val3 in (SELECT val4 FROM tab4 JOIN tab5 ON ... WHERE ...); -- Kit _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
