通过相同ID查询两张表中不同列各自的最大值并合并到一张视图表中

CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `root`@`localhost` 
    SQL SECURITY DEFINER
VIEW `v_2stm_head` AS
    SELECT 
        `rec_detail_2stma`.`SN` AS `SN`,
        `rec_detail_2stma`.`ContractNum` AS `ContractNum`,
        `rec_detail_2stma`.`ModelName` AS `ModelName`,
        `rec_detail_2stma`.`TimesA` AS `TimesA`,
        `rec_detail_2stmb`.`TimesB` AS `TimesB`
    FROM
        (`rec_detail_2stma`
        JOIN `rec_detail_2stmb`)
    WHERE
        ((`rec_detail_2stma`.`SN` = `rec_detail_2stmb`.`SN`)
            AND (`rec_detail_2stma`.`TimesA` = (SELECT 
                MAX(`t`.`TimesA`)
            FROM
                `rec_detail_2stma` `t`
            WHERE
                (`t`.`SN` = `rec_detail_2stmb`.`SN`)))
            AND (`rec_detail_2stmb`.`TimesB` = (SELECT 
                MAX(`t`.`TimesB`)
            FROM
                `rec_detail_2stmb` `t`
            WHERE
                (`t`.`SN` = `rec_detail_2stmb`.`SN`))))