[프로그래머스_mysql] 취소되지 않은 진료 예약 조회하기

---

https://school.programmers.co.kr/learn/courses/30/lessons/132204

프로그래머스

 

---

문제

---

풀이

SELECT B.APNT_NO, A.PT_NAME, A.PT_NO, B.MCDP_CD, B.DR_NAME,B.APNT_YMD
FROM PATIENT A 
JOIN (SELECT  B.APNT_NO,  B.PT_NO , A.MCDP_CD, A.DR_NAME, B.APNT_YMD
     FROM DOCTOR A 
     JOIN APPOINTMENT B
     ON A.DR_ID = B.MDDR_ID
     WHERE B.APNT_CNCL_YN ='N' AND A.MCDP_CD ='CS') B
ON A.PT_NO = B.PT_NO
WHERE B.APNT_YMD LIKE '2022-04-13%'
ORDER BY B.APNT_YMD