mysql - 我需要在 MySQL 中组合两个选择查询

Question

我想将第二个查询合并为第一个查询结果中的一列。

第一个查询:

Select
  snpc_stats.gamedetail.Player,
  Sum(snpc_stats.gamedetail.Points + snpc_stats.gamedetail.Hits) As Points,
  COUNT(*) As 'Games Played',
  Avg(snpc_stats.gamedetail.Finish) As 'Average Finish',
  Sum(snpc_stats.gamedetail.Hits) As `Total Hits`

From
  snpc_stats.gamedetail Inner Join
  snpc_stats.games On MOM_snpc_stats.games.GameID =
  snpc_stats.gamedetail.GamesID

Where
  snpc_stats.games.Season = '2014 Season'

Group By
  snpc_stats.gamedetail.Player, MOM_snpc_stats.games.Season

Order By
  Points Desc

第二个查询:

Select
  snpc_stats.gamedetail.Player,
  Sum(snpc_stats.gamedetail.Finish) As Second

From
  snpc_stats.gamedetail Inner Join
  snpc_stats.games On MOM_snpc_stats.games.GameID = snpc_stats.gamedetail.GamesID

Where
  snpc_stats.gamedetail.Finish = 1 And
  snpc_stats.games.Season = '2014 Season'

Group By
  snpc_stats.gamedetail.Player, snpc_stats.games.Season

不知道如何解决这个问题...

Answer 1

将以下列添加到第一个查询中的 select 语句中:

sum(if(snpc_stats.gamedetail.Finish = 1, 1, 0)) as Second

由于您在两个查询中按相同的内容进行联接和分组，因此您应该能够将其添加为列，而无需任何进一步的联接或子查询。