SELECT
  hero.name AS 'hero',
  hero.missionID AS 'heroMID',
  mission.missionID AS 'missMID',
  mission.description as 'mission'
FROM
  hero, mission
WHERE
  hero.missionID = mission.missionID;