DROP TEMPORARY TABLE IF EXISTS TABLE_1;
CREATE TEMPORARY TABLE TABLE_1
(
SELECT *
FROM
(
SELECT '100YUAN' vMoney,'5REN' vNum,'2015-09-15' vDate
UNION ALL
SELECT '200YUAN','6REN','2015-09-21'
)a
);
DROP TEMPORARY TABLE IF EXISTS TABLE_2;
CREATE TEMPORARY TABLE TABLE_2
(
SELECT *
FROM
(
SELECT '2015-09-15' vDate
UNION ALL
SELECT '2015-09-16'
UNION ALL
SELECT '2015-09-17'
UNION ALL
SELECT '2015-09-18'
UNION ALL
SELECT '2015-09-19'
UNION ALL
SELECT '2015-09-20'
UNION ALL
SELECT '2015-09-21'
UNION ALL
SELECT '2015-09-22'
UNION ALL
SELECT '2015-09-23'
UNION ALL
SELECT '2015-09-24'
) a
);
SELECT a.vDate,IFNULL(b.vMoney,0) vMoney,IFNULL(b.vNum,0) vNum
FROM TABLE_2 a
LEFT JOIN TABLE_1 b ON a.vDate = b.vDate
ORDER BY a.vDate