On 9 May 2012, at 2:20am, YAN HONG YE <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
