Sample SQL:
Requirement: Delete with Not exsits join in where condition
DELETE ITM FROM InventItemInventSetup ITM
WHERE NOT EXISTS (SELECT 1 FROM INVENTTABLE IT WHERE IT.DataAreaId = ITM.DataAreaId
AND IT.ITEMID = ITM.ITEMID)
AND ITM.DATAAREAID in ('USMF')