MySQL数据库UNION ALL和CROSS JOIN函数的简单使用

 UNION ALL函数：

SELECT SUM(c_money) as year FROM tb_consume 
    WHERE DATE_FORMAT(c_date,'%Y') = (select DATE_FORMAT(NOW(),'%Y')) 
UNION ALL
SELECT SUM(c_money) as month FROM tb_consume 
    WHERE DATE_FORMAT(c_date,'%m') = (select DATE_FORMAT(NOW(),'%m')) 
UNION ALL
SELECT SUM(c_money) as day FROM tb_consume 
    WHERE DATE_FORMAT(c_date,'%Y%m%d') = (select DATE_FORMAT(NOW(),'%Y%m%d')) 
UNION ALL
SELECT COUNT(c_money) as yearc FROM tb_consume 
    WHERE DATE_FORMAT(c_date,'%Y') = (select DATE_FORMAT(NOW(),'%Y')) 
UNION ALL
SELECT COUNT(c_money) as monthc FROM tb_consume 
    WHERE DATE_FORMAT(c_date,'%m') = (select DATE_FORMAT(NOW(),'%m')) 
UNION ALL
SELECT COUNT(c_money) as dayc FROM tb_consume 
    WHERE DATE_FORMAT(c_date,'%Y%m%d') = (select DATE_FORMAT(NOW(),'%Y%m%d'));

UNION ALL函数结果集：

 CROSS JOIN函数：

SELECT * FROM (SELECT SUM(c_money) as year FROM tb_consume 
    WHERE DATE_FORMAT(c_date,'%Y') = (select DATE_FORMAT(NOW(),'%Y'))) t1
CROSS JOIN
(SELECT SUM(c_money) as month FROM tb_consume 
    WHERE DATE_FORMAT(c_date,'%m') = (select DATE_FORMAT(NOW(),'%m'))) t2 
CROSS JOIN 
(SELECT SUM(c_money) as day FROM tb_consume 
    WHERE DATE_FORMAT(c_date,'%Y%m%d') = (select DATE_FORMAT(NOW(),'%Y%m%d'))) t3
CROSS JOIN 
(SELECT COUNT(c_money) as yearc FROM tb_consume 
    WHERE DATE_FORMAT(c_date,'%Y') = (select DATE_FORMAT(NOW(),'%Y'))) t4
CROSS JOIN 
(SELECT COUNT(c_money) as monthc FROM tb_consume 
    WHERE DATE_FORMAT(c_date,'%m') = (select DATE_FORMAT(NOW(),'%m'))) t5
CROSS JOIN 
(SELECT COUNT(c_money) as dayc FROM tb_consume 
    WHERE DATE_FORMAT(c_date,'%Y%m%d') = (select DATE_FORMAT(NOW(),'%Y%m%d'))) t6;

 CROSS JOIN函数结果集：