[프로그래머스,SQL,JOIN] #10.없어진 기록찾기

https://programmers.co.kr/learn/courses/30/lessons/59042

 

SELECT O.ANIMAL_ID, O.NAME
From ANIMAL_INS  I right join  ANIMAL_OUTS O on I.ANIMAL_ID = O.ANIMAL_ID
where I.ANIMAL_ID is null
order by O.ANIMAL_ID

[더 알아보기]

1. JOIN에 관해서 더 알아보자