记随笔

DELETE a.*
FROM
EST_BIND_HOUSE_EQUALLY a
LEFT JOIN EST_BIND_HOUSE_COST b ON a.house_id = b.house_id
AND a.cost_value_id = b.cost_value_id
where a.house_id = 3333 and a.cost_value_id = 11111
AND b.house_id IS null
and b.cost_value_id IS NULL

图片来自于https://blog.youkuaiyun.com/daweiwangzi/article/details/44863325