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
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.
2 matches
Mail list logo