[sqlite] two table update question

[YAN HONG YE]

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

[Simon Slavin]

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.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users