없어진 기록 찾기

답
-- 코드를 입력하세요
SELECT ANIMAL_OUTS.ANIMAL_ID, ANIMAL_OUTS.NAME from ANIMAL_INS right join ANIMAL_OUTS on ANIMAL_OUTS.ANIMAL_ID=ANIMAL_INS.ANIMAL_ID where ANIMAL_INS.ANIMAL_ID IS NULL order by ANIMAL_OUTS.ANIMAL_ID;