[JOIN/LEVEL3] 있었는데요 없었습니다 (MySQL/Oracle)

MySQL/Oracle

SELECT A.ANIMAL_ID, A.NAME
FROM ANIMAL_INS A, ANIMAL_OUTS B
WHERE A.ANIMAL_ID = B.ANIMAL_ID
AND A.DATETIME > B.DATETIME
ORDER BY A.DATETIME