SELECT w.match_id, w.winner_name, l.loser_name 
    FROM   winners AS w, losers AS l
    WHERE  w.match_id = l.match_id