from mktxhglb b inner join suhang06.pcbnet2002.dbo.mktxhglb a on a.pdctno=b.pdctnowhere a.pdctno in (
select pdctno from #ppe002)
and a.pdctno<>‘1071007A0‘
a表字段替换B表字段
原文：http://blog.51cto.com/215363/2341601
