[JOIN/LEVEL3] 없어진 기록 찾기 (MySQL/Oracle)

MySQL/Oracle

SELECT A.ANIMAL_ID, A.NAME
FROM ANIMAL_OUTS A LEFT OUTER JOIN ANIMAL_INS B
ON A.ANIMAL_ID = B.ANIMAL_ID
WHERE B.ANIMAL_ID IS NULL