[sqlite] two table update question

alter table myref add stkcode varchar(30); update myref set stkcode = dzhhq.stkcode; this sql command couldn't run in my sqlite. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] two table update question

On 9 May 2012, at 2:20am, YAN HONG YE 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.