15★] 프로그래머스 없어진 기록 찾기

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

코딩테스트 연습 - 없어진 기록 찾기

SELECT ANIMAL_OUTS.ANIMAL_ID, ANIMAL_OUTS.NAME 
FROM ANIMAL_OUTS
LEFT OUTER JOIN ANIMAL_INS 
ON ANIMAL_OUTS.ANIMAL_ID = ANIMAL_INS.ANIMAL_ID 
WHERE ANIMAL_INS.ANIMAL_ID IS NULL
ORDER BY ANIMAL_OUTS.ANIMAL_ID;

SELECT O.ANIMAL_ID, O.NAME 
FROM ANIMAL_OUTS AS O
LEFT OUTER  JOIN ANIMAL_INS AS I ON O.ANIMAL_ID = I.ANIMAL_ID 
WHERE I.ANIMAL_ID IS NULL
ORDER BY O.ANIMAL_ID;

 

 

futurists.tistory.com/17

[MySQL] 7장 조인 : JOIN (INNER, LEFT, RIGHT)

 

 

www.w3schools.com/sql/sql_join.asp

SQL Joins