yanhong.ye <y...@sohu.com> wrote: > update tb1 set col1=(select col1 from tb2 ) where tb1.co2=tb2.co2;
The closing parenthesis is in the wrong place: update tb1 set col1=(select col1 from tb2 where tb1.co2=tb2.co2); -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users