DELETE ITS
FROM ITS LEFT OUTER JOIN FATISL ON ITS.FATISLID = FATISL.FATISLID WHERE ITS.FATISLID IS NOT NULL AND FATISL.FATISLID IS NULL AND ABILDIRIMID IS NULL AND FBILDIRIMID IS NULL AND DBILDIRIMID IS NULL
GO

UPDATE ITS SET FFATISLID = NULL
FROM ITS LEFT OUTER JOIN FATISL ON ITS.FFATISLID = FATISL.FATISLID WHERE ITS.FFATISLID IS NOT NULL AND FATISL.FATISLID IS NULL AND FBILDIRIMID IS NULL 
GO