mysql - 两个查询合二为一 [MYSQL] 一个结果

Question

你们能帮我把两个查询合二为一吗？这是我的第一个查询:

SELECT estimated_sum_all, story_point_sum_all, time_spent,  reg_date
FROM burndown_snap_all  WHERE project_id='72'

结果:

 | estimated_sum_all | story_point_sum_all | time_spent | reg_date |
 | 300               | 20                  | 20.30      | 2017-09  |
 | 300               | 20                  | 19.30      | 2017-09  |
 | 300               | 20                  | 18.30      | 2017-09  |
 | 300               | 20                  | 15.32      | 2017-09  |

这是我的第二个查询:

SELECT time_spent FROM status_history_hours where
project_id = '72'

结果:

| time_spent | 
| 20.30      |
| 20.30      |
| 20.30      |
| 20.30      |

我想做的是构建一个 mysql 查询，该查询必须包含从第二个查询中选择/加入到 time_spent 的查询。决赛 table 应该是这样的:

 | estimated_sum_all | story_point_sum_all | time_spent | reg_date |
 | 300               | 20                  | 20.30      | 2017-09  |
 | 300               | 20                  | 20.30      | 2017-09  |
 | 300               | 20                  | 20.30      | 2017-09  |
 | 300               | 20                  | 20.30      | 2017-09  |

问候，

解决方案如下:

SELECT t1.id, t1.estimated_sum_all, 
t1.story_point_sum_all, t1.time_spent, 
t2.id, t2.time_spent FROM 
burndown_snap_all t1, status_history_hours 
t2 WHERE t1.project_id = 72 AND 
t2.project_id = 72 group by t1.id 

但是如何同时按t2.id分组呢？？？

Answer 1

SELECT estimated_sum_all, story_point_sum_all, time_spent,  reg_date
FROM burndown_snap_all  WHERE project_id='72'
UNION ALL
SELECT time_spent FROM status_history_hours where
project_id = '72'