php - 在我的情况下如何组合多个查询(选择语句)？

Question

第一个查询为我提供了表所需的字段(klass、Liikmenimi、synniaeg、Tiim 等。 )

 query("
   SELECT klass, nimi, synd, teamnimi, start, TIME(`finish`) AS finish FROM bc2014 T1 
   INNER JOIN bc2014aeg T2 on T1.bc2014_id = T2.bc2014_id
   WHERE klass = 'DS1 (1 koera toukerattavedu al.14 a.)' ");

在 phpMyAdmin 中:

select timediff(time(finish), time(start)) AS aeg FROM bc2014aeg

给我表中“时间”所需的结果

就我而言，如何合并这两个？

Answer 1

您应该能够将字段添加到语句的选择部分

 query("
   SELECT 
     klass, nimi, synd, teamnimi, start, 
     TIME(`finish`) AS finish,
     timediff(time(finish), time(start)) AS aeg
  FROM bc2014 T1 
   INNER JOIN bc2014aeg T2 on T1.bc2014_id = T2.bc2014_id
   WHERE klass = 'DS1 (1 koera toukerattavedu al.14 a.)' 
 ");