DELETE 使用 JOIN

DELETE FROM WIPPrdSpec
FROM WIPPrd P,WIPPrdSpec S
where S.ProdNo=P.ProdNo
and S.SetName='AntiSpecNo'
and P.Ptype='17010'