알고리즘/SQL

[프로그래머스 SQL] 있었는데요 없었습니다

빙빙 2021. 7. 20. 20:46
SELECT A.ANIMAL_ID, A.NAME 
FROM ANIMAL_INS AS A JOIN ANIMAL_OUTS AS B
WHERE A.ANIMAL_ID = B.ANIMAL_ID AND B.DATETIME <= A.DATETIME 
ORDER BY A.DATETIME