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

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" "T1" JOIN "ship" "T2" ON "T1"."Ship_ID" = "T2"."Ship_ID"