SELECT T1.code, T1.fate, T2.name FROM mission AS T1 JOIN ship AS T2 ON T1.ship_id = T2.ship_id
What are the mission codes, fates, and names of the ships involved?
CREATE TABLE mission (
    mission_id number,
    ship_id number,
    code text,
    launched_year number,
    location text,
    speed_knots number,
    fate text
)

CREATE TABLE ship (
    ship_id number,
    name text,
    type text,
    nationality text,
    tonnage number
)