없어진 기록 찾기

 

 

 

 

 

 

 

 

 

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