SQL 多表查询及批量删除

1、多表查询

根据表setproduct表条件ProductCatalog = 'FSL'，查询出的ProductType,查询SetStep工位是fs160R的所有数据

SELECT DISTINCT s.*
FROM SetProduct p
INNER JOIN SetStep s 
  ON p.ProductType = s.ProductType
WHERE p.ProductCatalog = 'FSL'
  AND s.StationCode = 'fs160R';
2、多表查询删除

DELETE s
FROM SetStep s
INNER JOIN SetProduct p 
  ON s.ProductType = p.ProductType
WHERE p.ProductCatalog = 'FSL'
  AND s.StationCode = 'fs060R';