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
SELECT T1.Code ,  T1.Fate ,  T2.Name FROM mission AS T1 JOIN ship AS T2 ON T1.Ship_ID  =  T2.Ship_ID
[{'Code': 'VMV-1', 'Fate': 'Decommissioned 1950', 'Name': 'Corbridge'}, {'Code': 'VMV-2', 'Fate': 'Decommissioned 1950', 'Name': 'Farringford'}, {'Code': 'VMV-3', 'Fate': 'Lost (burned) 1931', 'Name': 'Dromonby'}, {'Code': 'VMV-4 Former: Sterling', 'Fate': 'Retired 1939', 'Name': 'Trader'}, {'Code': 'VMV-5', 'Fate': 'Decommissioned 1959', 'Name': 'Ariadne'}, {'Code': 'VMV-6', 'Fate': 'Decommissioned 1960', 'Name': 'Appam'}, {'Code': 'VMV-7', 'Fate': 'Lost (burned and sunk) 1933', 'Name': 'Clan McTavish'}]