select
    a.id                           as claim_id,
    a.first_notification_of_loss,
    c.first_name                   as witness_first_name,
    c.family_name                  as witness_family_name
from
    claim a
    left outer join
    witness b
    on a.id = b.claim_id
    left outer join
    person c
    on b.person_id = c.id
order by
    claim_id;