12/04: MySQL > Delete with a LEFT JOIN
Category: Web dev
Posted by: hajime osako
MySQL Delete with a LEFT JOIN
DELETE EventLog.* FROM EventLog e LEFT JOIN CustInfo c USING (CustID) WHERE c.CustID IS NULL;
DELETE EventLog.* FROM EventLog e LEFT JOIN CustInfo c USING (CustID) WHERE c.CustID IS NULL;