On 9 May 2012, at 2:20am, YAN HONG YE <yanhong...@mpsa.com> wrote: > alter table myref add stkcode varchar(30); > update myref set stkcode = dzhhq.stkcode; > > this sql command couldn't run in my sqlite.
It does not know which row from the table dzhhq it is meant to use. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users