------update suhang06.pcbnet2002.dbo.mktxhglb set a.remark = b.remark
from mktxhglb b inner join suhang06.pcbnet2002.dbo.mktxhglb a on a.pdctno=b.pdctno
where a.pdctno in (
select pdctno from #ppe002)
and a.pdctno<>'1071007A0'
转载于:https://blog.51cto.com/215363/2341601