CREATE TABLE _Tausif
SELECT im.InvoiceNo,0 IsValidate FROM invoicemaster im
WHERE im.`EntryDate`>='2021-05-01 00:00:00';

UPDATE _Tausif t
INNER JOIN `f_ledgertransaction` lt ON lt.`InvoiceNo`=t.`InvoiceNo`
SET t.`IsValidate`=1;

DELETE im.* FROM _Tausif t
INNER JOIN invoicemaster im ON im.InvoiceNo=t.InvoiceNo AND t.IsValidate=0
WHERE im.`EntryDate`>='2021-05-01 00:00:00';