mysql - 如何将这两个查询合并为一个。？

Question

这是我的两个查询 当我分别解雇他们时我给出了正确的答复但是当合并时他们不给出相同的答复。请帮助将它们组合起来

SELECT SUM(hours) AS S1
,operating_company
 FROM Hours WHERE operating_company='AP-OH' GROUP BY operating_company

SELECT COUNT(*) AS S1,event_type
,operating_company
 FROM Event WHERE operating_company='AP-OH' AND event_type='OSH Restricted' GROUP BY 
 operating_company,event_type

谢谢拉杰什B

Answer 1

你可以这样做:

SELECT
  e.event_type,
  e.operating_company,
  SUM(h.hours) AS S1,
  COUNT(e.*) AS S2
FROM Hours h 
INNER JOIN event e ON h.operating_company = e.operating_company
WHERE h.operating_company = 'AP-OH' 
  AND e.event_type        = 'OSH Restricted' 
GROUP BY e.operating_company, e.event_type;