yanhong.ye <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
