[프로그래머스] 조건에 부합하는 중고거래 댓글 조회하기 (SQL)

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

프로그래머스

SELECT 
    UGB.TITLE, 
    UGB.BOARD_ID,
    UGR.REPLY_ID,
    UGR.WRITER_ID,
    UGR.CONTENTS, 
    DATE_FORMAT(UGR.CREATED_DATE,'%Y-%m-%d') AS CREATED_DATE
FROM
    USED_GOODS_BOARD UGB INNER JOIN USED_GOODS_REPLY UGR ON UGB.BOARD_ID = UGR.BOARD_ID 
where
    YEAR(UGB.CREATED_DATE) = 2022 AND MONTH(UGB.CREATED_DATE) = 10
ORDER BY 
    UGR.CREATED_DATE ASC, UGB.TITLE ASC

 

배운점

- INNERJOIN을 이용하여 같은 두 테이블간의 일치하는 행을 가져오도록함