delete from EMP
 where EMP_CODE in (
   select EMP.EMP_CODE
     from EMP
          inner join EMP_INVALID on EMP.EMP_CODE = EMP_INVALID.EMP_CODE
    where EMP_INVALID.VALID_FLG != '1'
 );