On 10 May 2012, at 2:28am, YAN HONG YE <[email protected]> wrote: > I means: > use another table column, to update the current table column: like this: > alter table myref add upfu; > update myref set upfu =dzhhq.upfu where exists (select * from dzhhq where > myref.stkname=dzhhq.stkname); > > but it said no such column: dzhhq.upfu > but dzhhq.upfu really exist.
I still don't understand what you want, but you should be able to do it in two commands: one command does a SELECT to find the value you want the other command does an UPDATE to change the value in the row to this value Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
