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?
[Schema (values) (types)]: | ship_mission |  mission : mission_id (text) , ship_id (number) , code (number) , launched_year (text) , location (number) , speed_knots (text) , fate (number) | ship : ship_id (text) , name (number) , type (number) , nationality (text) , tonnage (number);