我有基本上每个部分都包含相同字段的列表表。
- p_xl_cj_ticket_m_site_data | - p_xl_cj_ticket | - p_xl_cj_ticket_last_row_ingroup
- p_xl_jabo1_ticket_m_site_data | - p_xl_jabo1_ticket | - p_xl_jabo1_ticket_last_row_ingroup
- p_xl_jabo2_ticket_m_site_data | - p_xl_jabo2_ticket | - p_xl_jabo2_ticket_last_row_ingroup
如果我要计算ticket1,ticket2,ticket3中的所有网站总数,该怎么办?
预期输出(上面3个表的总和):
当前代码:
SELECT COUNT( * ) AS tot_sites,
IFNULL( COUNT(
CASE WHEN p_xl_cj_m_site_data.m_date_target = DATE( NOW( ) )
THEN 1 ELSE NULL END ) , 0 ) AS todays_target,
IFNULL( COUNT(
CASE WHEN (p_xl_cj_m_site_data.m_date_target = DATE( NOW( ) )
AND p_xl_cj_ticket.t_status =9 )
THEN 1 ELSE NULL END ) , 0) AS todays_achieve,
IFNULL( COUNT(
CASE WHEN p_xl_cj_ticket.t_status =9
THEN 1 ELSE NULL END ) , 0 ) AS tot_in
FROM p_xl_cj_m_site_data
LEFT JOIN p_xl_cj_ticket_last_row_ingroup
ON p_xl_cj_ticket_last_row_ingroup.t_m_id = p_xl_cj_m_site_data.m_id
AND p_xl_cj_ticket_last_row_ingroup.t_req_type = '04_int_finish_ack'
LEFT JOIN p_xl_cj_ticket
ON p_xl_cj_ticket.t_id = p_xl_cj_ticket_last_row_ingroup.t_id
WHERE p_xl_cj_m_site_data.m_status =1
样本数据:
p_xl_cj_ticket_m_site_data p_xl_cj_ticket p_xl_cj_ticket_last_row_ingroup
------------------------------------------------------------------------------------
* m_date_target = 2019-02-13 * t_status = 9 * t_m_id = xxxxx123
* m_status = 1 * t_id = abc * t_id = abc
* m_id = xxxxx123 * t_req_type = 04_int_finish_ack
我当前的代码只是p_xl_cj的计数票。
如果要使输出像我的期望一样,该怎么办?
谢谢...
最佳答案
SELECT (
SELECT COUNT(*)
FROM <table>
) AS count1,
(
SELECT COUNT(*)
FROM <table>
) AS count2
关于mysql - 从多个表Mysql查询总数,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/54684850/