On 4/9/2012 9:12 PM, YAN HONG YE wrote:
update dzhhq set dzhhq.mlevel=
update dzhhq set mlevel=...
case
dzhhq.stkname=myref.stkname when 1 then 88 else 0
end;
What's myref? Which row of which table is myref.stkname supposed to come
from?
You might be looking for something like this:
update dzhhq set mlevel =
case when stkname in (select stkname from myref) then 88 else 0 end;
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
