DELETE 数据表中数据，其中字段与其他关联数据表的关联字段相同的方法

 

DELETE TA WHERE (TA.FA + TA.FB + TA.FC + TA.FD) 
IN (
SELECT TB.FA + TB.FB + TB.FC + TB.FD 
FROM TB
)

另外一个方式如下
 

DELETE TA
FROM TA 
INNER JOIN TB
        ON TA.P = TB.P
        AND TA.Q = TB.Q
        AND TA.R = TB.R
WHERE TB.X = 'K'