58 취소되지 않은 진료 예약 조회하기
SELECT APNT_NO, PT_NAME, P.PT_NO, D.MCDP_CD, DR_NAME, APNT_YMD
FROM PATIENT P JOIN APPOINTMENT A ON P.PT_NO=A.PT_NO
JOIN DOCTOR D ON A.MDDR_ID=D.DR_ID
WHERE APNT_CNCL_YN = 'N'
AND A.MCDP_CD='CS'
AND APNT_YMD LIKE '2022-04-13%'
ORDER BY APNT_YMD