CREATE TABLE ship (Name VARCHAR, Ship_ID VARCHAR)
CREATE TABLE mission (Code VARCHAR, Fate VARCHAR, Ship_ID VARCHAR)

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"