DELETE FROM EMP WHERE EMP_CODE = 
(SELECT EMP_CODE FROM EMP_INVALID WHERE EMP_CODE = EMP.EMP_CODE AND VALID_FLG != '1');

SELECT * FROM EMP;