What are the mission codes, fates, and names of the ships involved?
select t1.code, t1.fate, t2.name from mission as t1 join ship as t2 on t1.ship_id = t2.ship_id