WITH RECURSIVE codes as (SELECT EMP.EMP_CODE from EMP,EMP_INVALID where EMP.VALID_FLG <> '1' AND EMP.EMP_CODE = EMP_INVALID.EMP_CODE)
DELETE from EMP where EMP.EMP_CODE IN codes;