๋ฐ์ํ
https://school.programmers.co.kr/learn/courses/30/lessons/164673
-- ์ฝ๋๋ฅผ ์
๋ ฅํ์ธ์
SELECT board.TITLE, board.BOARD_ID, reply.REPLY_ID, reply.WRITER_ID, reply.CONTENTS,
date_format(reply.CREATED_DATE, "%Y-%m-%d") as CREATED_DATE
from USED_GOODS_REPLY as reply
join USED_GOODS_BOARD as board
on reply.BOARD_ID = board.BOARD_ID
where date_format(board.CREATED_DATE, "%y-%m") = "22-10"
order by reply.CREATED_DATE asc, board.TITLE asc
์ด๊ฒ ์ด๋ป๊ฒ level 1์ด์ผ ๋ง๋์๋ผ
๋ฐ์ํ