SELECT TR.REQ_NUM, TR.EVENT_NUM, TR.PAY_MONEY, TR.REQ_STAT,RP.PAY_STAT,
GE.GOODS_NUM, EM.EVENT_NM,
DATE_FORMAT(EM.EVENT_STA_DTTM, '%y.%m.%d') AS EVENT_STA_DTTM,
DATE_FORMAT(EM.EVENT_END_DTTM, '%y.%m.%d') AS EVENT_END_DTTM,
DATE_FORMAT(TR.REQ_DTTM, '%y.%m.%d') AS REQ_DTTM
FROM TB_REQUEST TR JOIN TB_REQUEST_PAY RP ON TR.REQ_NUM = RP.REQ_NUM
JOIN TB_GOODS_EVENT GE ON RP.EVENT_NUM = GE.EVENT_NUM
JOIN TB_EVENT_MANAGE EM ON GE.EVENT_NUM = EM.EVENT_NUM
WHERE TR.REQ_USER_ID = '' ORDER BY TR.REQ_NUM DESC
구매요청 내역
