DELETE
FROM dbo.EmployeeFile
WHERE
dbo.EmployeeFile.EMPLOYEEID IN (SELECT EMPLOYEEID FROM EMployee WHERE (IsActive = 0))