SELECT T1.Code ,  T1.Fate ,  T2.Name FROM mission AS T1 JOIN ship AS T2 ON T1.Ship_ID  =  T2.Ship_ID
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
select t1 . code , t1 . fate , t2 . name from mission as t1 join ship as t2 on t1 . ship_id = t2 . ship_id
What are the mission codes , fates , and names of the ships involved ?