mysql - 如何将两个查询合二为一并在单个查询中获得结果？

Question

SELECT SUM(commission) as regularincome FROM `tbl_member_commission` where mem_id=2 AND MONTH(cdate) = MONTH(CURRENT_DATE())

SELECT SUM(commission) as crowdfund FROM `tbl_member_comm_month` where mem_id=2 AND MONTH(cdate) = MONTH(CURRENT_DATE())

注意:- 两个表都有相同的列名:佣金、mem_id、cdate

Answer 1

如果这是每个子查询中的唯一记录，您可以使用CROSS JOIN:

 select a.regularincome, b.crowdfund
 FROM
    (SELECT SUM(commission) as regularincome FROM `tbl_member_commission` where mem_id=2 AND MONTH(cdate) = MONTH(CURRENT_DATE())) as a
    cross join 
    (SELECT SUM(commission) as crowdfund FROM `tbl_member_comm_month` where mem_id=2 AND MONTH(cdate) = MONTH(CURRENT_DATE())) as b