SELECT TU.NAME ,DATE_FORMAT(REBATE_APPROVAL_DATE,'%Y-%m-%d') AS APPROVAL_DATE,
RA.REBATE_APPROVAL_STATUS,RA.REBATE_APPROVAL_REMARK
FROM TT_BIG_CUSTOMER_REBATE_APPROVAL_HIS RA
SELECT TU.NAME ,DATE_FORMAT(REBATE_APPROVAL_DATE,'%Y-%m-%d') AS APPROVAL_DATE,
RA.REBATE_APPROVAL_STATUS,RA.REBATE_APPROVAL_REMARK
FROM TT_BIG_CUSTOMER_REBATE_APPROVAL_HIS RA