如何在该日期内选择日期和时间？

我读了几篇关于此的文章：选择最大日期，然后选择最大时间这似乎最有帮助，但我看不到实现它的方法。

有五个桌子。我加入他们。我只需要从第一张表中选择具有最高日期和最高时间的行，并从第二张表中选择相同的行，然后将其余行连接到其他某个值上。使用我编写的代码，我得到了多行。似乎时间选择不正确。

可以使用子查询中的子查询来完成。我已经尝试过这样的事情：

    SELECT * from table1 
    INNER JOIN table2 ON table1.date = table2.date AND table1.gm = table2.gm        
    INNER JOIN table3 ON table2.gm = table3.gm        ...
    WHERE table3.date = :date AND table4.date = :date ...
    AND table1.date IN(
        SELECT MAX(table1.date) FROM table1 WHERE table1.time IN(
            SELECT MAX(table1.time) FROM table1
    )
    )
    AND table2.date IN(
        SELECT MAX(table2.date) FROM table1 WHERE table2.time IN(
            SELECT MAX(table2.time) FROM table2        )
    )
    ORDER BY table1.id

问题是：在加入所有日期最高且时间最高的日期之后，如何获得单行？谢谢！

编辑：对此我感到抱歉。我忘了说我需要与表（gm列）中的特定值相关的最长日期的最长时间。因此，对于每个表中相同的.gm值中的每一个，该行都是一行（在示例中，我给它的名称是table1.gm和table2.gm ...），而不仅仅是一行。解决方案Nick和Salim提供了作品，但我没有解决问题。

编辑：解决了！在实现Nick的解决方案之后，我只是想添加GROUP BY cntrs_reper.gm_company_no，cntrs_reper.date。就是这样。对于一个表中的每一行，其他日期和时间都是最长的！谢谢大家。

编辑。如果这可以帮助您进行完整查询：

SELECT  cntrs_gm.gm_company_no                          AS      company_c_g,  
 bns_gms.ded_bns                                    AS      ded_bns_gms,  
     bns_gms.no_ded_bns                             AS      no_ded_bns_gms,  
     bns_gms.wag_ded_bns                            AS      wag_ded_bns_gms,  
     cntrs_gm.cur_credit                            AS      cur_credit_c_g,  
     cntrs_gm.cdrop                                 AS      cdrop_c_g,  
     cntrs_gm.total_jp                              AS      total_jp_c_g,  
     cntrs_gm.games                                 AS      games_c_g,  
     cntrs_gm.wgames                                AS      wgames_c_g,  
     cntrs_gm.doors                                 AS      doors_c_g,  
     cntrs_gm.power                                 AS      power_c_g,  
     cntrs_gm.total_in                            AS        total_in_c_g,  
     cntrs_gm.total_out                           AS        total_out_c_g,  
     cntrs_gm.total_acc                           AS        total_acc_c_g,  
     cntrs_gm.total_bet                           AS        total_bet_c_g,  
     cntrs_gm.total_win                           AS        total_win_c_g,  
     cntrs_gm.total_bonus                         AS        total_bonus_c_g,  
     cntrs_gm.date              AS      date_c_g,  
     cntrs_reper.gm_company_no                    AS        company_reper,  
 bns_reper.ded_bns                            AS        ded_bns_reper,  
     bns_reper.no_ded_bns                         AS        no_ded_bns_reper,  
     bns_reper.wag_ded_bns          AS      wag_ded_bns_reper,  
     cntrs_reper.cur_credit         AS      cur_credit_reper,  
     cntrs_reper.cdrop              AS      cdrop_reper,  
     cntrs_reper.total_jp                         AS        total_jp_reper,  
     cntrs_reper.games              AS      games_reper,  
     cntrs_reper.wgames             AS      wgames_reper,  
     cntrs_reper.doors              AS      doors_reper,  
     cntrs_reper.power              AS      power_reper,  
     cntrs_reper.total_in                         AS        total_in_reper,  
     cntrs_reper.total_out          AS      total_out_reper,  
     cntrs_reper.total_acc          AS      total_acc_reper,  
     cntrs_reper.total_bet          AS      total_bet_reper,  
     cntrs_reper.total_win          AS      total_win_reper,  
     cntrs_reper.total_bonus            AS      total_bonus_reper,  
     cntrs_reper.date                             AS        date_reper,  
     cntrs_reper.time               AS      time_reper,
     bns_reper.time                 AS      time_c_g,
     gms_cfg.gm_no                                    AS              machine_id,  
     gms_cfg.denom_cin                        AS              machine_cin  
     FROM bns_gms  
     INNER JOIN cntrs_gm  
     ON bns_gms.gm_company_no = cntrs_gm.gm_company_no  AND bns_gms.date = cntrs_gm.date
     INNER JOIN bns_reper 
     ON cntrs_gm.gm_company_no = bns_reper.gm_company_no  
     INNER JOIN cntrs_reper  
     ON bns_reper.gm_company_no = cntrs_reper.gm_company_no  AND bns_reper.date = cntrs_reper.date
     INNER JOIN gms_cfg  
     ON cntrs_reper.gm_company_no =  gms_cfg.gm_no  
     WHERE   bns_reper.date IN(
        SELECT MAX(DATE(bns_reper.date)) FROM bns_reper WHERE bns_reper.time IN(
            SELECT MAX(TIME(bns_reper.time)) FROM bns_reper
        )
        )
     AND cntrs_reper.date IN(
        SELECT MAX(DATE(cntrs_reper.date)) FROM cntrs_reper  WHERE cntrs_reper.time IN(
            SELECT MAX(TIME(cntrs_reper.time)) FROM cntrs_reper
        )
        )

     ORDER BY cntrs_gm.gm_company_no

数据库示例

bns_gms

bns_reper

cntrs_gm

cntrs_reper

gms_cfg