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