CREATE TABLE mission (Code VARCHAR(255), Fate VARCHAR(255), Ship_ID VARCHAR(255)); CREATE TABLE ship (Name VARCHAR(255), Ship_ID VARCHAR(255))
Show codes and fates of missions, and names of ships involved.
    
SQL: SELECT T1.Code, T1.Fate, T2.Name FROM mission AS T1 JOIN ship AS T2 ON T1.Ship_ID = T2.Ship_ID