있었는데요 없었습니다
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