左加入最新记录

SELECt  g.*, s.*FROM  GAMES gLEFT JOIN(    SCORES s  INNER JOIN  (    SELECt      n.game_id,  MAX(n.created_on) AS max_score_date    FROM      SCORES n    GROUP BY      n.game_id  )    y      ON  y.game_id        = s.game_id      AND y.max_score_date = s.created_on)    ON s.game_id = g.id