Show codes and fates of missions, and names of ships involved.
select t1.code, t1.fate, t2.name from mission as t1 join ship as t2 on t1.ship_id = t2.ship_id