없어진 기록 찾기

SELECT o.ANIMAL_ID, o.NAME FROM ANIMAL_OUTS o LEFT JOIN ANIMAL_INS i ON i.ANIMAL_ID = o.ANIMAL_ID WHERE i.ANIMAL_ID IS NULL ORDER BY 1 ASC ;