wilded
6/28/2019 - 10:51 AM

MYSQL DeleteRows not Present in another Table

DELETE FROM `tblSalesDetails` 
 WHERE NOT EXISTS(SELECT NULL
                    FROM `tblSales`
                   WHERE tblSales.`salID` = `salDetSaleID`)