YAN HONG YE <[email protected]> wrote: > update myref set upfu =dzhhq.upfu where exists (select * from dzhhq where > myref.stkname=dzhhq.stkname);
You are probably looking for something like this:
update myref set upfu =
(select dzhhq.upfu from dzhhq where myref.stkname=dzhhq.stkname);
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
