CREATE TABLE ship (ship_id NUMBER, name CLOB, type CLOB, nationality CLOB, tonnage NUMBER)
CREATE TABLE mission (mission_id NUMBER, ship_id NUMBER, code CLOB, launched_year NUMBER, location CLOB, speed_knots NUMBER, fate CLOB)

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"