union 联合查询 并且 按照创建日期倒叙排序。
SELECT
fundId,
storeCode,
blackListStatus,
fundStoreCode,
createTime,
updateTime,
auditTime,
storeReportStatus
FROM
(
SELECT
t.FUND_ID fundId,
t.STORE_CODE storeCode,
t.BLACKLIST_STATUS blackListStatus,
t.FUND_STORE_CODE fundStoreCode,
t.CREATE_TIME createTime,
t.UPDATE_TIME updateTime,
t.UPDATE_TIME auditTime,
'S' storeReportStatus
FROM
table2 t
UNION
SELECT
t1.FUND_ID fundId,
t1.STORE_CODE storeCode,
'0' blackListStatus,
NULL fundStoreCode,
t1.CREATE_TIME createTime,
t1.UPDATE_TIME updateTime,
t1.AUDIT_TIME auditTime,
t1.AUDIT_STATUS storeReportStatus
FROM
tabe1 t1
) dd
ORDER BY
createTime