select * from spkfk b ,hwsp a where hw='HWI00000001' and hwshl>0 and a.spid=b.spid and tongym like'%2'
我已经把条件选择出来了,但是想把,A表里的hwshl更新成0,条件就是where后边的
update hwsp
set hwshl = 0
from hwsp , spkfk b
where hw='HWI00000001' and hwshl>0 and hwsp.spid=b.spid and tongym like'%2'
联系客服