select
    a.name,
    b.name,
    a.boat,
    b.instrument
from
    sailor a
    full outer join
    musician b
    on a.name = b.name;